Search results

I have a form called project managers..... I would like to display only distinct managers. I tried to use a query that grabbed distinct managers, but then the recordset was not updatabable. Also, I am using a check box next to the manager text box so they can select the manager. Ideally, once...

Jerry, Sorry to bother you again.....I am still at work, but I wanted to see how the tools/database utilities/convert works, so I tried it here at work using Access 97 on a different database that I can open and the "convert" option is blanked out...?? Any suggestions why this would be? Will...

Jerry, I can open it at home using Access XP. (that is what I used to create it) I can not open it here at work using Access 97. I am going to try when I get home using Access XP go to Tools/DataBase Utilities/Convert Database and convert it to a previous version. Does this sound right...

I'm not for sure if I know what you are talking about when you say import the structure? I have created a blank database, get external data, and do an import, but still it says unrecognized database format. Is this what you were talking about....importing the structure. Thanks, Kacy ________...

Hello, Over the weekend I worked on a database using Access XP. I brought the database in to work this morning and attempted to open it using Access 97 and I am receiving the following error.... Unrecognized database format <filename>. (Error 3343) I spent all weekend creating forms...

Thanks, I got something to work over the weekend. I created a report and then a macro that runs a query that gets ALL from my table. So my command button runs that macro. Works fine Kacy ________ CoeD

Thanks, Kacy ________ Glass Blown Bowl

Casey....... I just got doing this. Write a query something similiar to this.... SELECT Inventory.* FROM Inventory WHERE [FORMS]![INVENTORY_FORM]![AUTO_NUMBER]=INVENTORY.AUTO_NUMBER; ------------------------------------------------------------------ * Selects everything [INVENTORY_FORM]...

I have a report that uses the following query to get it's info...... SELECT Inventory.* FROM Inventory WHERE [FORMS]![INVENTORY_FORM]![AUTO_NUMBER]=INVENTORY.AUTO_NUMBER; On my form I have a "Print Report" button that runs this query. My question is...... Is there anyway that I can get a...

On my form I have a textbox that looks up the autonumber. I use this field as a report number. On my report I use the same textbox that looks up the autonumber. I call it report #. So when the users print out all of the reports (there's tons of them) they can view the report number on the...

This is driving the users crazy..... When they are viewing a report that has more than one page it only show the first page. They would like to keep scrolling and for it to take them to the next page, and next and so on. At the bottom they can hit the arrow key to take them to the next page...

Hopefully this helps with the first section of your question.... On the field to where you would like to go after completing the subform........ 1.) Right click 2.)Properties 3.)Tab Index Set this to the consecutive number following your last field that you complete on your subform. Hope...

OK...I've got this far. I have a macro to run on the "exit" of this field. This is the macro.. 1.) Run Command - =DLookUp("[DL_NUM]","[APPOINTMENT]","[DL_NUM] = [Forms]![Appointment]![DL_NUM]") 2.) MsgBox - DL is already on file. Here is my problem. 1. ) When I enter a DL that is not a...

I surprised myself and figured this one out on my own. I looked in a book and it gave a little different syntax that the help file in access and it worked. Here's the difference in syntax..... =DLookUp("[ADDRESS]","[FACILITY]","[FAC_ID] = [Forms]![Appointment]![COMBO12]") Kacy ________...

I am receiving a #Error in a textbox of which I'm attempting to get my data from a DLookUp() function. Here is what I have in the textbox's ControlSource......... =DLookUp("[ADDRESS]","FACILITY","[FAC_ID] =" & [Forms]![Appointment]![COMBO12]) When I test the second part of this function in...

I'm not exactly for sure how or where to use the DLookUp() function. Any suggestions? Thanks. Kacy ________ Suzuki gs series specifications

I was hoping that it would be possible by using a msgbox and it's condition function since I know nothing about VB. Do you guys think that this may be possible or are you pretty sure that it can't be done by this using the msgbox function? Something like this..... Condition...

I have a table that does not allow duplicate Drivers license numbers. If a user enters a duplicate DL number into the the Form that I created, Access throws back the whole long duplicate record error. This scares the users. I would like to do some validation check were it checks the DL...

First you need to create a query similiar to this.... SELECT * FROM ????? WHERE [FORMS]![Name of your Form]![Primary Key Field]=????.Primary Key Field; Question marks being your table that the data resides in. Next create a report using the the query listed above for the data to be viewed...

Thanks..........It's working great! ________ WHOLESALE VAPORIZER