Search results

In that case, no global relationships were likely set up. You'll likely find the relationships within each query as you open them, and they may differ from query to query. It is not essential to access (but often helpful) to specify the relationships globally, so the developer may have chosen...

On your form, create a new combo box where you will enter the EAN you are searching for. Access will give you some options for the behavior for the combo box. Choose the "Find a record on my form..." option. Next, create a query that includes the EAN and the other info you want to know...

For what it is worth, I eventually implemented the solution here. I'm sure the more security-conscious of you are horrified, but it works for us so far with no problems.

Thanks Ken and plog. I think I will go with reorganizing my table structure. There are a couple of other issues that would be improved that way as well. Usually I'm pretty good about that, but this one seemed so straightforward with just a few criteria for each document that I opted for the...

I have a table that holds the dates of various approvals for documents. Approval Dates DocumentID ApproverA_DateApproved ApproverB_DateApproved ApproverC_DateApproved LastUpdated In a query, I'd like there to be a column with the date of the most recent approval (max date) for each document...

CJ_London - thanks for that link. I think I'll keep looking for other options in the hopes of not having to hacking registry files, though (which I'm sure our IT dept. would seriously frown on), but I'll keep that in mind. Our IT dept. doesn't mind changing a setting, they just aren't sure...

My IT department applied an update to our Office 2010 installations. Previously, when a user opened a database for the first time, or from a new location, they would get a “friendly” yellow button warning them that this was not a trusted document, and giving them the option to trust it...

Thanks! Okay, I'll just sanitize quotes, then. I'm not worried about sql injection - this is a local db for use by just a few people.

Any that would break an SQL statement called from within VBA. I know single and double quotes are problematic, and I'm pretty sure parentheses, brackets, # and * would cause problems as well. If there is a definitive list, that would help too. Thanks :)

Is there a function that will sanitize user-entered text and remove problematic characters for SQL? Or do I have to replace() each one individually?

I'd set up the tables differently - one customer can have multiple addresses, each with a start and end date. The one without an end date is current (or you could have a separate column for "Active"). You can use the end dates to order them. This will let you keep a more complete history and...

Thanks for the suggestions! That software looks absolutely perfect for what we want, and has way more bells and whistles than I would be able to program into the DB. It will take us months to get it approved and vetted, though, so in the meantime I guess I'll be hardcoding some logon data! CB

We have a database that is split. Every user has their own front end (installed via a .bat file so that the users always have a local copy of the most recent version), linked to a shared back end on a server. This seems stable and functional for us so far. However, because our users are...

Thanks. That style of audit trail has its value (see the link in my original post for one of the clearest descriptions of the two main audit types I've found), but also many disadvantages for our other purposes. We really need to stick with the record-level auditing that we have chosen. Given...

The main tables in my database have corresponding history tables. When records are changed, an insert query copies the entire changed record (table row) over to a new row in the correpsponding history table plus additional columns for DateChanged and WhoChanged that are autofilled. For...

Worked perfectly. Thanks!

I have a function that inserts some data into a table and logs the user who made the change (based on their windows username). This query works fine for users whose windows username is numbers only, but fails for those who have text in their usernames. When users with text in their names run...

CJ_London, I had to add a line of code to select the first line, and then your suggestion worked: Private Sub Form_Current() Forms![MedSearch].SelectDateBox.Requery Me!SelectDateBox.Selected(0) = True SelectDateBox_Click End Sub Thanks! CB

I have a form (about patients) containing a listbox (list of visit dates) and a subform (showing medications at that date). When you click on the listbox, the subform is re-queried with the selected date as a parameter to show the medications that were in use on that date. This is working...

Actually - that is perfect because there are a few other actions I would like to capture when adding a new item! Thank you, CB