Search results

If your backend is on a sql db I would suggest moving the code to a stored procedure.

I think one table should suffice. Table Inspections This table would have at least the following fields: InspectionID- PK- Autonumber SiteID-FK-Long InspectionType-FK-long ScheduledInspectionDate-Date And any other fields you need to schedule an inspection. You could also add any fields you...

Sorry about that misinformation. I misread the help on the check box. Upon re-reading it it indicated the event doesn't apply to checkboxes within an option group.

The after update event does not fire for check boxes - try putting your code in the on_click event

Have you tried moving the info in the page header to the detail section.

Take a look at the ADO Stream object.

Sounds like your simple database is morphing into a full blown inventory system. Make sure you have a complete list of the requirements and start modeling. Take a look at some of the data models available on the web to get an idea of what has worked for others. Based on the little bit of...

Based on your code - I would say yes both statements should be rolled back. Since both statements are on the same connection object and the transaction has not yet been committed both statements should be rolled back. I would test this by forcing an error in the second sub and check if the...

While I don't know of a good book or piece of software I do have an idea as to an approach to take. Convert a few of them and get comfortable with the syntax. Come up with as many as needed standard templates for the different types of functions you have and then write a code...

Looks like fTextHeight is a separate function that you need to include in your module. Recheck the site you found the function and see if you missed coping that one

If the sub VerticallyCenter is in a seperate module than the calling code ie. your form event - then yes it needs to be Public. If its a sub in the class module of the form than it only needs to be private. Most likely - you would want to define VerticallyCenter as Public in a separate module...

Glad to help - Remember to use the F1 Key

try this I'm assuming vntControl is an undeclared variant - it needs to be declared as a control Private Sub Form_Load() dim ctl as Control For Each ctl In Me.Controls If ctl.Tag = "Center" Then VerticallyCenter ctl End If Next ctl End Sub

DoCmd.OpenForm "frm_OrdersHOTHeadersOnlyWORKSHEET", acFormDS, , , acFormEdit

try this Private Sub Form_Load() For Each vntControl In Me.Controls If vntControl.Tag = "Center" Then VerticallyCenter vntControl End If Next vntControl End Sub

mkaeser All is doable with some minor changes to you systems and processes. 1. You will need to modify your Project table to include a field to store the Excel File Location and name - Basically a full path 2. Add VBA code or macro to the click event of this field calling the...

Thanks for the early morning chuckle. Keep on trucking - you are heading in the right direction

It not completely clear what you want to do. Do you want to update existing records with new information? Do you want to import the data to a new table? Do you want to attach the excel file to an existing record? All these things can be done and can be done with different approaches. For...

Here's an update to the code that works as you want. As it turns out - you need to add an Item to the Items collection of the destination folder. 'Error 429 occurs with GetObject if Outlook is not running. On Error Resume Next Set objOutlook = GetObject(, "Outlook.Application")...

Did you try removing the call to save as mentioned in my update post? I am not familiar with google apps outlook so I can't comment on why the move is not allowed. Im at work now building a deck - I will try somethings tonight if you can't get it working. Please update your status by end of day...