Search results

I have tried teh following sql in my append query (as I cannot select the form as an I had to use the sql to try and build it) It does not work and hence will not allow me to save the query... How do I get the append query to pick up values from the filtered form? INSERT INTO...

Do you mean something like this: Private Sub Form_Open(Cancel As Integer) Currentdb.execute INSERT INTO tbl_History SELECT (*) FROM frmStaffDetails_ComboBox [This is the form with the 50 fields I want to exposrt into a table] WHERE [I dont really have a where clause as the form is...

Kind of.... I used them last about 2 years ago... I get what they do, just cant remember how to set them up.... I'll do a search on this forum and see what I can dig up How would I get it to append a value from my form however...?

I dont understand what you mean by this? I expected to need code such as: "me.selectall.copy" and then "open.Tbl_history.paste" I just need to keep a copy of the historical data in a historied table before I make changes to the current record in the current table....(I think we discussed this...

I have a seperate form which filters the main form.... So it is possible that I will get many filtered results... e.g. if I filter on smith, I may get 4 results.. smith, Mark Smith, andrew Smith, Colin Smith, John.... If I exported this data to a table.... I wouldn't mind if all 4 records...

Hi All, Im trying to export the contents of a filtered form into a table called: Tbl_Temp_Historical_data **NOTE - This is not the table the form is bound too ** I want to export the data to this table everytime the form is opened and the values are displayed within the form's controls, hence...

This works really nicely as a combo box.. Only question is..... is it possible to have this as a free text box rather than a combo box? (I have c.2000 different surnames, so its not userfriendly to provide a drop-down box..) When I tried to do this, the code wouldn't let me type in it without...

Hi Ken, How would the user select the appropriate name they wish to filter on? For example if they wanted to select Mark Smith out of the options below... Smith, Michael Smith, Michelle Smith, Mark Is there a way to have a radio button etc? Or a way to select the row? I am probably just not...

Morning all, Is the following possible? I have a form which searches for an employee by name. Currently it opens the "frmMAIN" (which has c. 30 fields) based on the search results and the user has to flip through until they get the correct person. E.g. - Filter on Smith, M and the user would...

I am a muppet..... Twas the "_" I was missing! Thanks, have a great weekend! M

I put the following code within the AfterUpdate event of the cbo_Region properties... Private Sub cbo_Region_AfterUpdate() cbo_Country.Requery Me.cboCountry = Null SetFocus.cboCountry End Sub It did'ne work..... If you guys already tested this and it works... am I just putting the code...

Mmmmm i dont think Im explaining the prob very well.... When I change the region from Asia to Europe..... the country field will still be populated with Thailand... So it will look.... REgion: Europe Country: Thailand I want it to look: Region: Europe Country: [blank] so teh user defo...

:DHi all, I have 2 combo boxes "cbo_Region" which filters "cbo_Country" After updating "cbo_Region" I run this code which updates the list of values avail in the Country combo... Private Sub cbo_Region_AfterUpdate() cbo_Country.Requery End Sub Question: How do I get it to clear out the...

ah... tis fine... I ahve set the default value as 0 and the validation rule as Is Not Null and that seems to do the trick! Thanks, Mandy

Would I put that in the "default value" under properties of that field?

Out of interest.... when [Permanent Staff FTE] or [Temporary Staff FTE] is left blank [NULL] the calculated field [Total_FTE] stays blank.... I tried setting the default value of these fields to 0, but this didn't work... (it ignored it!) I would like it so that it caculates the total...

Ah... I read "macro" as being a VB module.... Have just used the macro button for the forst time and it works great. Thanks for the nudge in the right direction! Mandy

Mmmm so using tables as references for acceptable values is a good way to do things then? I'll re-jig if so as it would be easier for the user to add in new values this way... I was actually born in Consett... borderline Geordie really! M

Morning all, I have the following VBA to set a value in a form based on the calculation of two other variables within the form. Sub Test1() SetValue Item: [Total FTE] Expression: ([Permanent Staff FTE] +[Temporary Staff FTE]) End Sub (I used the microsoft help paegs to derive this...

I only have 1 table. This table is populated with both country and region. I almost want to look up the country and return the region.