Search results

Joy. No I meant docmd.transferdatabase. Sent from my SM-G950U using Tapatalk

I must be missing something? Can you not link the template to access under a generic name, query the spreadsheet then use docmd.transferdatabase to export the file where you want? Sent from my SM-G950U using Tapatalk

Variable = me.combox if within the form. You have to reference the form if not. Google it, pretty basic, tons of info out their already. Sent from my SM-G950U using Tapatalk

Have to have a differentiated variable. You have the table so what is unique in all your fields that will also always be true. Maybe you need to add a status field. This is fairly common. Since you are making updates you can set active or inactive at that time. Sent from my SM-G950U using Tapatalk

Make a cross reference table. Where your selection = the form to open. Then use dlookup to set the value of your variable strform. Strform = Nz(dlookup([columnnamewhereuhaveformname],"tablename", "choicecolumn = '" & strform & "' "), msgbox "not found") Air code so I am sure the syntax needs...

You could make function and create a record set equal to your query and loop though them. I do the same to compare downloaded files with todays date to the count of needed files. It's easy and runs fast.. Function nameoffunction() as integer Dim rs as DOA.recordset Set rs =...

Dstart = format(Range("'Sheet1'!A7").Value, 7, 10),"mm/dd/yyyy") Dstart = mid(dstart,7,10) Dstart needs to be a string... But if you just want the year why not right(yourdate,2).... Sent from my SM-G950U using Tapatalk

Well then you can create the variance by creating two functions one sums the in db lines the other not in db lines. Then a sub where the is variance = variance1 - variance 2 where 1 and 2 are the functions you created. You can write each function many ways but Sql is likely easiest. Or you could...

Still not real sure what "this" is but it's access so most likely. Can you make a text box = A variable, sure. It's me.textbox1 = how ever you contrive a value. Where textbox1 is the name of your forms textbox. U could bind the text box to a query where the check filed = no. That would be the...

Keep your code and change datetimein to a public function. Sent from my SM-G950U using Tapatalk

Try Function DateTimeIn() as string DateTimeIn = now() End function That should get the stamp you want but you have to do something with it. Like me.textbox12 = DateTimeIn within your login procedure... Sent from my SM-G950U using Tapatalk

Share point is just slow imo. Use and append sql to only add a single record. Sent from my SM-G950U using Tapatalk

I think you are on it. After some testing today noted auto process shows as system. I'll have to program around that and all should be well. Now that I know I just put a long sleep on and kick it off as I head out the door. Once I figure it out 100% will post the solve.

Sure had not but will look into it. Sent from my SM-G950U using Tapatalk

I can try that, anything is worth a shot. It works fine when I run the DB myself though. I came in this a.m. and all client files were updated / ready to send and the error trap had 1 error 91 for each client e-mail. Opened the module, hit F5 on the launcher and 30 minutes later had 6 e-mail...

What I am doing: 1. Automated Process Kicks off 8 p.m. every night 2. Process concludes by sending out and e-mail with attachment. What is happening: 1. If I cycle thought no issues 2. If I manually kick off the process no issue 3. Each night the entire process runs except the e-mail 4...

Iif(Left(Right([yournum],2),1)=".",mid([yournum],1,len([yournum])-2,mid([yournum],1,len([yournum])-4)) or something like that assuming the data is constantly .x or _-_A. Yournum is the field you need to inspect. Put this in the build function of your query and update yournum. Once you get it...

ht tp://p2p.wrox.com/access-vba/5637 0-creating-media-player-1 1-object-access-vba.html Try searching media player vba automation. Sent from my SM-G950U using Tapatalk

Lol Sent from my SM-G950U using Tapatalk

Snarky are we:D I had the time and am a nice guy.