Search results

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

On a subform that records notes in datasheet view (columns: Date, Note; sorted in reverse chronological order with newest at the top), is there a way to get the blank new record line to appear at the top? Otherwise, you have to counter-intuitively scroll down below the oldest entry to enter a...

Here is the code I use for a button on a form that will print a report corresponding to the current record and open up an email with the recipient blank. You can hard-code any variable (to, subject, body) by modifying this code slightly. It doesn't send the email - just opens it up so you can...

I think you should look at the left and right joins in your query. Right click on one of the arrows between your two tables. Let's say you have customers, some with orders, some without. Right now, you probably have your link to include all customers and then the orders associated with them...

These are .mdb files. I think Mihail came the closest. I first tried what Mihail suggested (making a new copy of BE and relinking my FE), and that didn't work. However, then I made a copy of my FE, and deleted then relinked the tables, and that seems to have fixed the issue. I'm not sure...

The FE that I am using is my own personal copy of the data-entry FE on my own personal hard drive - not the network (although it accesses the shared BE via linked tables). I have verified that they are running the correct read-only FE directly from their hard drives (not a shortcut or other...

I have a split database. The back end is in a public folder on our network. There are two front ends - one that is read-only (dozens of users), and one that is used to enter data (2 users). The users all copy their appropriate front end to their desktops and use it from there. I am doing...

Since the table doesn't exist, that didn't work. However, one table was linked to another database, and apparently someone else had named a table the same as my old table in THAT database, and the relationship was from there. Thanks for your help!

Whenever I try to add a new record to a form, I am getting a message that "You cannot add or change a record because a related record is required in table "TableDietOld". I did create a table with this name when I was fiddling with the database. However, it no longer exists. I am trying to...

Thanks michaelryan78! That was the kicker. No idea where I got those quotes from. The final working code now reads: If Access.Version > 13 Then DoCmd.SendObject acSendReport, stReport, acFormatPDF, , , , stSubject, stEmailMessage, True, "" DoCmd.OutputTo acOutputReport, stReport...

Thanks KCLNick and Paul. Here is my updated code that incorporates your suggestions, but still does not save the file, and returns error 2501. CB myPath = "J:\Diet Cards\" 'I removed stCaption from here so that I could check the directory by itself 'This returns a message box saying that...

The code below is from one of my projects where people prepare meat and vegetable products at different stations (tables). It does some of what you want to do, and I think you could modify it for your needs. First, the code looks to a form to see which stations need to be printed. Then it...

Thanks, but unfortunately the 2007 folks cannot export to PDF. You have to install a service pack, and our IT folks will not do this because they are slowly rolling out 2010. For whatever antiquated reasons, people regularly use the .xps format internally around here. Strange, but true. I...

I'm trying to figure out why I can email a report as a PDF, but not save it as a PDF using the code below? When I save, I get the dreaded error 2501. The searching I did for this said to uninstall and reinstall printers (I've done that - seems to have no effect), or took issue with...