Search results

A couple things I notice by just looking at the db for a couple seconds; 1) Never use non-alphanumeric characters in field names. This means no special characters like @#$! and no spaces! 2) Keep in mind in some areas, there are laws regarding the security and storage of credit card numbers. 3)...

Or you can try a combobox and put the SQL string in the RowSource. If you want to become familar with SQL strings, start using the built-in query wizard, then in query desgin view, click the button that switches between "Preview" and "Design View" in the query, and there's an option to see the...

So Do I understand correctly, You have three tables; Categories Recipes & Containers A Category could have more than one recipe and a recipe could have more than one container? You may need to have one table that holds possible containers and another that holds the actual container values...

That should work. I figured I would have to open a recordset, but as far as cycling through each record, I'm a little lost. I've tossed around ideas in my head like "For Each" or "Do Until rs.EOF" along with "rs.MoveNext" but I'm a little foggy beyond that. I like to figure things out without...

Hello everyone. It's been a while! I've managed to hold my own due to everything I learned right here on the forum, but alas I've run into a road-block. I have this code to generate an email with plain-text It takes a bunch of fields from a single-form (we'll call it "Deliveries") and sticks...

I know I'm a little late, but try MyMessage = chr(13) & "" instead of MyMessage = "" chr(13) is the code for a Carriage Return also try different combinations with chr(10) which is a LineFeed character

We don't need no stinkin' IT! I am using the OnChange event of the field with an if-then statement; Works fine for me. If Field1.NewValue <> Field1.OldValue then AddAudit Field1.OldValue, Field1.NewValue, fOSUserName(), fOSMachineName(), Now(), Etc End If

Yes, this is an access question, I just used Excel to show a representation of my audit trail table. Your idea of storing initial values in variables upon opening moving to a record and then recording the changes when the form is closed is a pretty good idea. It would also have to run if the...

I have an audit trail table that stores every change made to a particular field. It stores EVERY change, so if a user opened the form changed the field to one thing and then changed it back to another, the audit trail stores it as two changes, but essentially the user just changed it from one...

Okay. I know I'm totally answering my own thread here, but I have some good news! I found a simple solution to the following situation: 1) The form really needs to open like a custom dialog box (even if the previous form was maximized, this form will open and resize itself to the normal size)...

I found out what the problem is: When both the form's Pop Up and Modal properties are set to Yes, The Filter options are disabled. By making the form Modal but not Pop Up, I get all the filter options back. I don't know if I can live with that though, because then the form will auto-resize...

I have a form that is set to Single Form. It has a subform. The form has navigation buttons on the bottom and it allows me to 'browse' through all the records. I have the filter/sort buttons on my menu bar, but they are greyed out. Even when I right-click on a field to filter by selection or...

You said the db is on a shared drive? Do you mean it is stored on another PC, or is it on a network server? You probably need to change the linked-table paths to UNC paths \\server\path\ or \\computer\sharedfolder\ instead of mapped drives like Y:\ Or you have to make sure that all machines...

Access User and Group security is still the best bet. The code above provides what we call "security through obscurity"... Try this: Create a new mdb, then go to File -> Import and select your db that has the shift-key disabled... and watch in horror! Also, Access database passwords are...

That's Beautiful! DoCmd.RunSQL "INSERT INTO ActiveUsers ( User )" & _ " VALUES (fOSUserName());"

OK, I have another problem.... very weird but probably very simple. I am now fine-tuning the Append query that creates a record for each instance of the db that the user opens. i.e. If the user opens two instances of the db, then two records get created, each with their own unique session id...

Thanks Bob, " & Session & " worked for me because Session is a long integer. I tried '" & Session & '"" earlier but of course it didn't work because the variable is not text... That's what my problem was. DoCmd.RunSQL "DELETE ActiveUsers.*, ActiveUsers.Session" & _ " FROM ActiveUsers"...

One more question: If the user opened multiple instances af Access and the db on their machine, would the "Session" public variable be unique for each instance, or would the public variable "bleed" over to the other sessions as well?

AH! I didnt know that, but it makes sense. Thanks!

I have a table called active users which has an autonumber field called Session and the table also stores the username and date. The record is appended to the table when the user opens the db. That works fine. What I need now, is when the user closes the main form (which causes an...