Search results

I think you need this in the F_PANumRequest: Private Sub Form_Current() If Me.NewRecord Then Me.[ProjectID] = Me.OpenArgs End If End Sub Cheers,

Sorry for the delay in getting back, here is an updated version of the code (full disclosure: I did not write the original code, I found it on the web many years ago when I was dealing with form corruption in a .mdb file) in which I included the savetotext\loadfromtext for macros. I am not sure...

Just got back from skying and saw that you solved the initial problem - hurray! Any particular reason why you would delete the objects (tables) and not simply refresh the data in them using a delete\append query combination? I can see the need for what your doing if the table structures change...

@Marshall Brooks: Thanks for the detailed explanation on the user forms, seems like you have them "under control" so I agree that moving away from them at this point would be unwarranted. Hopefully you can identify if one of them is causing the error and maybe just replace that one with some...

What can I say, never saw or had a need for them, are there any references set in your VBA project to enable these? Why not use the InputBox function instead of a third party user form? Good luck with this, please keep us posted if you can. Cheers,

Here you go Pat. @Marshall Brooks: I am also attaching a .bas file with the module from Allen Browne, I imported into one of my files and compiled the code with no errors. Could you please post a screen shot of the VBE window showing the user forms you mention, this is what mine looks like, all...

Sounds like there might be some corruption in forms as well (what exactly do you mean by userforms, as that is Excel terminology, in Access we have forms). Here is an updated module, I put some message breaks in the code so you could see where it stops; investigate the output folder and see...

You tried to open the newly created db right, not the one in which you ran the code? Try to comment out the On Error Resume Next and see if you get any errors that might point to the issue. Cheers,

Wayne, Please have a look at the updated file. tblPosition needed its own primary key (autonumber) but you had CompanyID as autonumber, you cannot create a relationship between those and wouldn't be one to many as intended. I also changed the name of the Date field in tblCompany as that is a...

Here is an old module I have that would use savetotext\loadfromtext to restore a front-end, I successfully used a few times to remove corruption in front-end files. The code was written for mdbs but I didn't see anything in it that would prevent it from running inside an accdb file. Import it...

I don't think we can help you with what you provided, look at the error description and try to understand the cause; you probably have duplicates in a field used in the join when you shouldn't or you have missing key(s) in one of the tables. Without analyzing the actual data you won't be able to...

Maybe you have the original rule associated with the wrong control? Cheers,

Thank you Colin, interesting stuff as usual! Cheers,

You are not saying what your problem is: are you getting a runtime error (if yes then on which line and what is the error number and description),you are getting incorrect results, etc. Cheers,

Sure :) Cheers,

The form is trying to simulate the interface used to build a pivot table (which used to be included with Access). It allows to select a query as the source and then start selecting the data elements (rows, columns data fields, etc.). It would then create a new Excel and export the query data to...

Look into adding Docmd.OutputTo to your button's Click event: https://access-excel.tips/access-vba-docmd-outputto-method/ Cheers,

acViewPreview would also work; acHidden is the WindowMode argument vs the View argument the default for View is acViewNormal which prints the report). Cheers,

Please review the attached sample. Cheers,

It doesn't have to be done manually (you have to open it in design view to change the caption) Cheers,