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...

I had thought that initially too, but I checked with everyone. This is also happening to another Access XP database we have. Any configurations I should have set?

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?

Heather, that worked like a charm, thanks so much. Thanks everyone for your help. Happy New Year.

Im a little confused about the strName = PersonsNameFromTable. In the table named Firm Directory, I have a list of over 700 names, I need these names to come out on the report, but in a way that will display the notary and initials. Thanks

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 mikevh, Yes, thats exactly what the update query looks like in SQL View, it is UPDATE Matter SET Matter.MatterComment = ChangeStr([MatterComment],Chr$(10),Chr$(13) & Chr$(10),0); Im pretty sure that the knowledgebase gave me the correct code, im just still baffled why this keeps giving me...

Also, forgot to add, that the module compiles without any errors, however, the article explains to create an update query with that fieldname of the that I need to fix: Here is the update query they advised me to use: ChangeStr([<fieldname>],Chr$(10),Chr$(13) & Chr$(10),0)

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 &quot;you must create a project plan&quot;. 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...

Hello Again, here is what I have so far using the code you provided. The code compiles fine, however, I am not getting the succesfully created message from the MsgBox, so something is still wrong with the code. Please review and reply, thanks so much, ----------- Public Sub...

Thanks for your reply, however, I am very very new to VB coding and could use some help in narrowing down this code to do the following: What I need is to set the password to the user accounts that I have already created (whose default passwords are now blank). And not to create new user...

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...