Search results for query: *

Hi All, I have a table that gets updated from a linked table through an update query I created. This database is the source of a intranet site of ours. Heres the problem, on all of the fields in which I have combo boxes, they seem to get updated, that is, the value shows up in the field...

Copies of a multi-user database are being created automatically with the number 1 following the name. Does anyone know why this is happening and how I can prevent this from happening?

Hi All, I need help in creating an Event Procedure on Format for a report listing employee names. Here is what I need to do. I have two fields in my database (1)Notary (Yes or No dependent on that person being a notary) and (2)Initials (Either has a value or has a Null value-which stores their...

Hi All, I am trying to run this code (in an Access XP module) that I copied off of the MS Support Site to convert the CR character used in Microsoft Excel to the CR character used in Microsoft Access (Knowledge Base Article 115576). I followed all of the directions, and even tried looking for...

Hi All, I have a field called Secretary (which populates the loginID of the Secretary selected in the combobox - its record source is a query), and a field called Secretary UserCode. I need to automatically fill in the Secretary UserCode field in this format (FirstNameLastName), a combination...

Hi All, I have a combo box that shows two values when you click on it, however, when I select a value and move to another field, only one value stays. The field is a lookup and writes an ID into the table. Let me make this more easier to understand, I have 2 values in combo box, a person's...

Hi All, I need to create a msgbox function that will only display a message (and not prompt the user for any information or action) when the user types in a value in a field that is greater than 1. I want the message to say "you must create a project plan". Im not sure how to go...

I need to create a parameter query for a report that will prompt the user to enter more than one value entry for a field. For example, it should prompt the user to enter either one or more than one application number, and then have the report display those records that match up with the...

Hello, I have linked 2 SQL tables into my access database for the purpose of having combo boxes pull up this data. Lets assume, combobox1 looks up table1 data and combobox2 looks up table2's data. Here is where Im stuck::: when the user clicks on combobox1 and selects from the drop down list...

Hi All, I have set up a group in Access and have placed the individual user accounts into that group. Here's my issue: I want to assign the same password to all of these user accounts, is there a way that I could run some code to accomplish this instead of me signing onto access with each...