Search results

Mmmmm.... it works great for viewing records... when I create a new record however it does not update? (I put it in the "Default value" of the data tab of the properties....) also, within the 1st combo box... how do I display only 1 column? (The 1st column - country?) thanks, Mandy

Mmmmm.... it works great for viewing records... when I create a new record however it does not update? (I put it in the "Default value" of the data tab of the properties....) also, within the 1st combo box... how do I display only 1 column? (The 1st column - country?) thanks, Mandy

I have a combo box with 2x columns: Country Region I want the user to select the country (from a list using a combo box) and the Region to auto-populate without user intervention (e.g. if they select France - Europe will auto-populate). I have seen this done before, but I cannot find an...

Latest silly Q: What are tables level lookups? Im kind of hoping that they are not where you have several tables which the combo box looks up to as this is exactly what I had in mind.... How do table level lookups cause problems? and what is the alternative... would it be setting them directly...

I may have a further complication.... When the user updates a field..... I need to restrict the entiry they are allowed to make.... e.g. if they change from being Part-Time to Full-Time....The following values are the only acceptable ones.... FT PT I cannot allow the user to free-type...

Mmmm... Uber unsure now.... although in a good way as now I have 2 solutions rather than none! As I am a newbie to all of this and I have to next generate "Access Reports" (so a different forum will be bored by me!) are either of these solutions easier to set-up / maintain or easier to write...

Ahh..... I think I am with you now.... By taking a copy into a temp table, I am leaving the old record alone and happily sitting in the "main" table... hence I cant override it when I write back the "new" record from the temp table to the main table. Is that what you mean? And I will have to...

Hi missingling - sorry about double post - I though I wasn't explaining myself very well, hence tried a second time. The penny has dropped that this will not be as simple as I had thought it would be however. Apologies. Neileg - I followed through your idea and I have split it down into several...

I need to be able to track changes users make to their details. e.g. for every staff member (who has a unique StaffID) they may change building / desk / team / leave / move internally / go from Full Time to Part-time etc. I need the user to be able to update their details, and store the update...

Afternoon all, I have a form with 7 columns of data. When a user updates any part of this data I want to repopulate a new row in my table, leaving the old one untouched. Access usually updates the row directly in the table, how do I prevent this and keep the old and keep the new? Im really...

Hi all, I have a form which populates a table. When the form is used I would like to populate the table with the "username" of the person who po[pulated it. Previously I used to use: =Environ("UserName") in the default value of the table. However, now that Im on XP from reading this forum...

I was intending on using a max function on the date in order to get the most current field. I only have 2000 rows of data to contend with and the changes are likely to be infrequent (I hope!) i really cant think of any other way of getting the results I need... "the powers that be" would like...

works a treat... thanks so much! Regards Mandy

I want the last name to match exactly but I wanted the user to be able to select starts with "m" or starts with "ma" if they entered "m" then the results returned would be Smith, Michael Smith, Mandy Smith, Michelle etc.... so that if the user enetered "ma" in the first name field only the...

I have read several (and there are hundreds!) of posts on audit trails using the search forum on this site... none of them really seem to do what I need.... the Ghudson solution looked very good, but then it only updated for new fields and I would like to populate the entire row again with the...

Sadly not.... I imagine I just have the commas etc in the wrong place, but I have tried so many different variations of this code, I cant see the wood for the trees anymore....! I get the same error as before with your code above.....

I am trying to filter a form on two fields (one being a wildcard) For example where: Last name = smith First name begins with = m* The code falls over at: stLinkCriteria = "[Last_Name]=" & "'" & Me![StaffLastName] & "'" And "[First_Name] Like " & " '" & Me![StaffFirstName] & "'*" Can...

Hi all, I have form which I would like the end-user to be able to use to update fields, for example: First Name Last Name Building Country etc... trouble is I need to be able to track changes. I have a unique StaffNumber with I have used as the key. So if a staff member changes Building I...