Recent content by PJname

Thanks sxschech but how would this be put in the Autoexec macro as the first step? Is this a module?

I have a morning job that I have scheduled to kick off at 0300 am each morning where I work. What I would like to do as one of the first steps in the Autoexec macro is to rename another database to prevent users accessing while this update is running and once the update has completed, rename...

Help...... I am trying to update tables within an MS Access database and I continue to receive this message this morning...... NOT ENOUGH SPACE ON TEMPORARY DISK I have this running on my c:\drive and it shows that I have 15.8 GB free space. I tried to run from a network directory, but...

Using the following code to perform Database backups to a directory. Seems to be working correctly. Function CompactDB3() On Error GoTo CompactDB3_Err Const conFilePath = "<current DBF location>" Const conFilePath3 = "<directory where copy is to reside>" newday4 = Now()...

I would like to set up a backup function in a MS Access database where it will go and perform backups of other MS Access databases located in various directories . Can someone send me the VB code to do this? Thanks in Advance.....

Thanks to all for your assistance in providing VB code for compacting databases. I have the following code and it seems to be working for compacting MS Access Databases.....I will set this up in my autoexec file to run as the last step. ' This is used to compact the...

Hello Ed2020 trying to use the VB coding you sent me but receiving compile errors. I am not a VB code person expert so this is what I plugged in: General information: directory location: J:\oschd\access\pam Database name & compact from: testcompCODE.mdb Compact to: testcompCODE1.mdb...

Can someone direct me to where I can find VB coding to be included in a Microsoft Access Database to run a compress on other MS Access databases which are located in different directories and naming conventions? What I would like the VB coding to do - is to include this action in my Autoexec...

I have a MS Access database that I have set up to automatically run using the Scheduled Tasks application at certain time early in the mornings using the Autoexec Macro in the Access database. Sometimes when I login to my machine the next morning, it shows the following Microsoft Access box...

Thanks MajP, I tried using your coding, but received a compile error on the following: Compile error: Method or data member not found Private Sub Form_Load() DoCmd.MoveSize 0, 0, 6650, 5200 ' Create an instance of our FormatByCriteria class Set TB = New clsTabs ' You MUST set the...

Hello VRoscioli, I have modified the Caption property naming what I want each tab to display. Is there a way that I can change the font color for each tab? I discovered how to change the font size, weight, etc.

Is there a way that you can change the font size, color, text, etc.. when using the TAB control in a form? If so, can you send instructions? Thanks in advance.

Hello genomon, I decided to start from scratch in creating my query and overwrite the query that I was having the problem with. I had a deadline to meet. Thanks for responding.

Question: Is there a way to check for duplicate fields in a Microsoft Make table query? Trying to perform a Make table and receive the following error: Cannot define field more than once I know that I can start over, but would like to prevent this due to complex criteria defined.

[surprise] [surprise] [surprise] Well, I think I have solved the problem. When all else fails, SHUTDOWN your Machine and try again. I did this and looks like it solved the problem I was having with Excel function=networkdays Who would have thought. I appreciate all the suggestions...