Search results

Go into the data properties of your form and set it to Data Entry

Use the concatenate command -> ColumnName: Field1 & ", " & Field2 & ", " etc...

Have you searched for "normalization"? That is going to be your first step in building this database. The way you have the tables laid out are not normalized. You really need to ask yourself what you hope to achieve by using Access instead of Excel. Did you read the article I linked to? If so...

There is really no easy way to edit data from a list box. You could do somthing funky using the double-click event or something whereby it would stich the selected record to the opposite of whatever it was, but typically listboxes aren't used for data entry.

Try using SELECT DISTINCT

That's pretty much what I'm doing... I'm setting it with a variable that I define first. Thank anyway!

I suggest you start by doing a search for "normalization" and read all you can. Expecting Access to behave like Excel is not realistic. They are different programs that are designed to do different tasks. I'd also suggest that you read this article about when to use Access vs Excel.

Just some ideas: First, I would create a recordset with all of your user ids: set rs = currentdb.openrecordset("SELECT Distinct UserID FROM tblTable",dbOpenDynaset) Then, I would loop through that recordset, creating a new recordsets for each userID: Do while not rs.EOF set rsResults =...

Hello, I have a problem. I have a Pass Through query that I have saved (qryPassThrough) and I am using some VBA code to update the SQL statement in the query, like such: Dim qdf as QueryDef set qdf = CurrentDb.Querydefs("qryPassThrough") qdf.SQL = "Insert SQL here..." The error occurs on the...

Try using Dcount. You can find the syntax in help.

This should get you started.

Ahhhh, makes sense... I figured that when you kicked off the batch file it would execute before you had a chance to quit the database. Thanks!

Maybe a dumb question - but how do you call a .bat file from Access after you've already closed it? I understand how you would check the version when you open the database, but I don't get how you'd call the .bat file after closing it...

Why don't you just bind the combox to Client_ID? Otherwise, on the after update event of the combox, you would use: me.txtClientID = me.cboClientID

The most simple answer is to not allow them access to the table!! There is no way to change the values stored in a combobox from a combobox, so as long as you have "Limit to List" enabled, and the user can't see the table, they won't be able to change the list.

I don't know. If you want, post the db and i'll take a look.

I may be wrong, but I think that would need to be enforced via your forms, as i don't think it can be done in the relationship itself.

What data type is [ClientK_ID] ?

No... if you right click on the control, click on properties, and then click on the other tab, you will find the name of the control. Access does sort of a stupid thing and names the control the same name as the field to which it is bound. This is generally bad practice, as it confuses things...

Do a search for "Audit Trail."