Recent content by lioninwinter

Many thanks for this constructive comment - yes I should do some walking first

Can someone else help here :)

I would still want the code to be driven by values I plug in as variables so I don't need to keep constructing queries. I am a little more comfortable in VBA than SQL. There will be other times when I'll want to replace a hard value of a table or a field with a variable, so all I'm looking for...

The rest of the sub will rename the values 1, 2, 3 etc depending on how many duplicated values there are. This is only step 1

Thank you for this but what is the syntax for placing a string variable in arguments 1 and 2 in DCOUNT i.e. in place of "[EventID]" and "tblEvents"? I want to replace these two 'hard' values with variables myTF, myTN whose values would change depending on which field name / table name I assign...

0 I am relatively new Access vba user and having problems with the synatax for the use of DCOUNT with variables. I am constructing a simple routine to look for duplicates in the [EventShort] field of a table called tblEventsi. The first step is to count the occurrences of each of the strings in...

Thank you Carletto (I hope that is the right name). I am not sure if there was an earlier post or if you were picking up the thread from other comments. In any event I'll get my database cleaned up and post it. Comments would be much appreciated. David

Thank you Minty - I read the thread and it was actually inspiring as well as being helpful.

I love this post and the fact you were gutsy enough to post it and ask for people to help. I have to say from my perspective your language seems not just fine but actually very elegant - I'd love to be able to write like you. I hope others with better Access skills than I were able to help and...

Dear Access World community: Apologies if this is not the right pace to ask the question; admins please feel free to redirect me. I am based in the UK somewhere between being a beginner and intermediate Access user and use the program for developing a database for a history project for a PhD...

I have a set of user defined keys and deliberately omit to check data-integrity requirements for the relationships because the IDs change quite often. What is the best way to update the primary key of a particular key across all tables? Is there a VB routine that would do this?

Many thanks for your help. I am a social historian and am building a database to analyse data from historical records such as parish registers. The registers were obviously intended administrative purposes that are different from ours as historians. A typical entry is like this: "John son of...

Thank you for your help. I'm wondering if a 'where' query can be entered directly into the control source field of the form?

Thank you so much for your help. I have tried the "where" query method; the issue is updating the query requires opening and closing the table and form for the update to take place. Is there any easy solution except the approach of using a combo box with all values entered individually?

Microsoft itself warns against the use of the Dlookup function in Access but having become accustomed to VLOOKUP in Excel, I am keen at least to try to use the similar function in Access. Can someone help with the attached example in which a simple Dlookup of "GDes" on GID loops endlessly. Any...