Search results

Thank you, I removed the dots to test and it didn't seem to make a difference. But I will keep them out just in case. I just noticed also that when it does the print preview and then closes the report for each person, it's opening the same person's report more than once. Could it be something...

Using the second page of this thread (https://access-programmers.co.uk/forums/showthread.php?t=206372&highlight=outputto) I am able to export a report that is filtered by person and save it under their name and today's date, but it is taking over 5 minutes to export 3 1 page reports. There are...

Thank you both! I went the easier route jdraw posted for now because I'm in a time crunch, but will definitely try out the other one when I get a chance. For now it is working by linking my Add New Provider form to the Edit List button. Super easy. Thanks!

Thank you Ranman. I have the Add Provider button and a data entry form that opens to type in the name and address. This will be used by a team of people, so I will probably hide the toolbar. I was hoping that when they type in a new provider, the new ProviderID (autonumber) will pass over to the...

I have a form with customer information. The information will be imported from Excel and someone will move through each record and add the provider information to it. There is a Provider table which holds the name and address. There is a combobox to choose a provider, which then displays the...

My own stupid mistake! After changing the drive to my desktop as a test and it worked, I found when using the long network path that I was missing a folder. :banghead: For anyone else looking for it, this is the code that works to export each person's report to a folder: Private Sub...

Thank you, I have updated it as you said, but I am still getting the same runtime error and stuck on the same line of code.

Thank you for your response. I changed it as you suggested to: Collateral QC Reports"\& rst![ProcessorName] & Format(Date, "mmddyyyy") & ".pdf" and I get a Compile error: Syntax error. Also, should the processor name part be as above or should it be rst.Field("ProcessorName")? In my...

I have found several threads on this topic, and have found some code to get started with in this thread: http://access-programmers.co.uk/forums/showthread.php?t=206372&highlight=outputto&page=2 But after trying several tweaks, I just can't quite get it to work. I am fairly new to Access and...

I changed my delete button from the wizard created macro to this: DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand acCmdDeleteRecord and it seems to do the trick. Thank you!

Both relationships appear to be the same. Please see attached images. Thank you!

Do you mean the Edit button on the first form or the Delete buttons? For the Delete buttons I just used the wizard and have a macro.

I have a continuous form with all records from the table Main. It's purpose is for a supervisor to be able to correct a record if needed. Each record could potentially also have data on 2 related junction tables. I have added 2 Edit buttons on each record/row on the continuous form in case they...

Thank you for the info! That sounds a little above my skill level, but I will keep that on my list to play with when I get time. :-)

Thank you Jiri! How do I go about adding that? I've really only done code on forms, so I'm not sure where to even put it.

Oh man, that is terrible! I am terrified of losing data like that. This database has about 1,200 records added a day. Is there a way to have it automatically back up once an hour automatically without using any outside software?

That is perfect! Thank you so much!!

Here is a very stripped down version, but it still appears to do it, although not every time. I noticed it also does it if you open a table. If it doesn't do it, try closing out and opening again. Seems like it only does it the first time.

Actually, it's not closing the second form, it is just switching focus back to the first form. The tab for the 2nd form is still open.

The only thing in Form_Load is: Private Sub Form_Load() Me.Processor_SQ_Comment.Enabled = False Me.Frame115 = Null Me.Frame131 = Null End Sub