Search results

Thanks for that, I had no idea that they did not always go up in value :(

The error I am getting is that my table is already opend exclusively by another user. I changed the record source to a qry and I get the same error message unless I run the following before I open the popup. Also I try to add the code to the unload event with no luck...

I am trying to add this to a exit command button on the popup and I have tried Forms!frmMain_toplg!SubForm1.subfrmQualObservations.SourceObject = "subfrmQualObservations" And With no luck, I also dont get an error so I am not sure what to do with this...

Ok so I found a second solution but I am not sure its the best or if I should be doing it your way... Mine is very simple, I added "[tblObservation].[ObservationID]" To the order by area on the form I want to load. I have added about 15 records so far without issue.

Ok so that works every time but I found another problem with this setup. I am trying to use the following to show the last record in the form, or to say it better, I want it to show the newly created record from the code we used above. Private Sub Form_Load() If Not Me.NewRecord...

Thanks for the help but right now I cant even get the On Got Focus event to run. It might have to do with my setup this is the drilldown of my forms, I have a mainform that wraps the entire database as a navigation type tool and then I just change the subforms as the user changes menu options...

Hey guys I change a subforms SourceObject so that a popup can be used to edit the records or add new ones. This works with the following code. Now I want to close the popup and repopulate that subform, I thought the 'On Got Focus' event would do it but for some reason its not.... Any idea...

Thanks! they are both numbers so your solution worked!

I am trying to use the below code to add in two values into a table but I cant seem to get the VBA right. DoCmd.RunSQL "INSERT INTO tblObservation ([fk_QualificationID], [fk_SiteID]) VALUES " & Me.QualificationID.Value, Me.SiteID.Value & ";" I get the following error: An expression you...

Sure thing, but my issue is not the relationships as much as how to make it easy for the users to add data into the tables. I am getting better at VBA/SQL but this is a little over my head. I attached the Relationships for my join tables so you can see. This one is a few days old and I have...

Ok the only way I have ever created a Many to Many connection was with a Join table. With my most recent project I am having a really hard time creating a UI that is easy for my users to work with. I came across the new multivalue option for the lookup tables in access 2007. It seems like...

Can I provide anymore info to help with this one?

I did google this one but I am still having problems. I have a form for a Site Audit, in the form I want my users to be able to select two things Site Staff and the Audit Staff, Each site audit can have multiple staff and multiple auditors. Both Site Staff and Audit Staff are in the same...

Well it seems this might have been my own mistake. I was getting confused by my cbobox filter and my record sorce filters. I will post back if there is a 'REAL' issue.

Ok I have a subform that's record source filterd with the following query: SELECT tblSiteStaffQualificationJoin.*, tblSiteStaff.IsAuditor FROM tblSiteStaff INNER JOIN tblSiteStaffQualificationJoin ON tblSiteStaff.SiteStaffID = tblSiteStaffQualificationJoin.fk_SiteStaffID WHERE...

If you are working with Access 2007: Select the table you would like to export Click the External Data TAB on the access ribbon In the export section click on the little excel icon A wizard will help with the next steps.

I have removed the Auditor table and all the related join tables. I then added in the flags: Auditor/SiteStaff to the SiteStaff table. Now I am looking at the other side of the image posted above, I dont know that I can join up the tables because I want to report on them as follows. SiteHQ...

I would get the globe ones, but keep in mind: The ones with the Globe are your remote tables on the SQL server. The ones with the SSMA i think are backups when you migrated to SQL (you sure these are not the orignal tables you are looking for?)

I am sure there might be a better way but till somone posts that I will post the way I create a local verson from SQL. Open a database with the ODBC connection to all the tables on the SQL server Open a second database you would like to create a local table Copy a table from the ODBC...

Just adding in a image to help figure out a better way... if there is one.