Rabu, 21 Juni 2023

Re: [MSAccessProfessionals] DLookup not working

you can also create a function to Pick the correct color (see fnColor1 on Module1) and call the function on your
Update query (see Query2).

On Wed, Jun 21, 2023 at 4:27 AM Duane Hookom <duanehookom@hotmail.com> wrote:
I'm not sure if any file came through since I'm using my cell phone. 

You mention a query and DLookup but didn't provide the SQL view and data types of significant fields. This would be the minimum information required to get an accurate response. 

Duane

Sent from my mobile

On Jun 20, 2023, at 2:56 PM, porag379@gmail.com wrote:

Sir, Good evening. This is porag and I'm Microsoft Access learner. I want to use DLOOKUP in Access Table for pull data from difference Table but can't it. Could you help me?  Attached my Simple access database where I've created a update query with Dlookup function but not working. Could you point out my mistake?

Thanks
Porag
<TestData.accdb>



--
Arnelito G. Puzon


_._,_._,_
Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116386) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_
Diposting oleh di Tidak ada komentar:

Selasa, 20 Juni 2023

Re: [MSAccessProfessionals] DLookup not working

I'm not sure if any file came through since I'm using my cell phone. 

You mention a query and DLookup but didn't provide the SQL view and data types of significant fields. This would be the minimum information required to get an accurate response. 

Duane

Sent from my mobile

On Jun 20, 2023, at 2:56 PM, porag379@gmail.com wrote:

Sir, Good evening. This is porag and I'm Microsoft Access learner. I want to use DLOOKUP in Access Table for pull data from difference Table but can't it. Could you help me?  Attached my Simple access database where I've created a update query with Dlookup function but not working. Could you point out my mistake?

Thanks
Porag
<TestData.accdb>
Diposting oleh di Tidak ada komentar:

Re: [MSAccessProfessionals] DLookup not working

myNewData=lookup("myField","myTable",myvar & "= MyFieldName")
This will look in the table, myTable for a field named myField, where the MyFieldName = the value of myvar.



On Tue, Jun 20, 2023 at 3:56 PM, porag379@gmail.com
<porag379@gmail.com> wrote:
Sir, Good evening. This is porag and I'm Microsoft Access learner. I want to use DLOOKUP in Access Table for pull data from difference Table but can't it. Could you help me?  Attached my Simple access database where I've created a update query with Dlookup function but not working. Could you point out my mistake?

Thanks
Porag
_._,_._,_
Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116383) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_
Diposting oleh di Tidak ada komentar:

[MSAccessProfessionals] DLookup not working

Sir, Good evening. This is porag and I'm Microsoft Access learner. I want to use DLOOKUP in Access Table for pull data from difference Table but can't it. Could you help me?  Attached my Simple access database where I've created a update query with Dlookup function but not working. Could you point out my mistake?

Thanks
Porag
_._,_._,_
Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116382) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_
Diposting oleh di Tidak ada komentar:

Jumat, 02 Juni 2023

Re: [MSAccessProfessionals] VBA Export to excel issue

Thank You so much for your responses. 
My thought was to kill the existing file in the folder and then have the process replace it. But I decided to try another way according to the users requests. 

Thank You

Jim Wagner
From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Paul Baldy <Pbaldy@gmail.com>
Sent: Thursday, June 1, 2023 9:12 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] VBA Export to excel issue
 
>> I know that exporting to an existing excel does not overwrite it adds the new sheet. 

Not in my experience, at least not with OutputTo.  

Paul

------ Original Message ------
From: "Cheeseburger" <Michael.P.Devlin@hofstra.edu>
Sent: 6/1/2023 6:54:15 AM
Subject: Re: [MSAccessProfessionals] VBA Export to excel issue

When you say killpath,are you killing the file first?  I know that exporting to an existing excel does not overwrite it adds the new sheet. 

Diposting oleh di Tidak ada komentar:

Kamis, 01 Juni 2023

Re: [MSAccessProfessionals] VBA Export to excel issue

>> I know that exporting to an existing excel does not overwrite it adds the new sheet. 

Not in my experience, at least not with OutputTo.  

Paul

------ Original Message ------
From: "Cheeseburger" <Michael.P.Devlin@hofstra.edu>
Sent: 6/1/2023 6:54:15 AM
Subject: Re: [MSAccessProfessionals] VBA Export to excel issue

When you say killpath,are you killing the file first?  I know that exporting to an existing excel does not overwrite it adds the new sheet. 

Diposting oleh di Tidak ada komentar:

Re: [MSAccessProfessionals] VBA Export to excel issue

When you say killpath,are you killing the file first?  I know that exporting to an existing excel does not overwrite it adds the new sheet. 
Diposting oleh di Tidak ada komentar:
Langganan: Postingan (Atom)