Search results for query: *

Hello, I have unique prefixes depending on what user is working on. When user needs a new number, I query database, find the last entry, remove the prefix and generate my next number in sequence. There are times when users are needing to generate multiple sequential numbers for a prefix. As...

I have two tables. PAMMain has an AutoNumber field, DwgNumID. My other table, PAMInfo, originally didn't have a field that I could use to join via the DwgNumID. I have a problem where I need to create the DwgNumID field on my table PAMInfo so that I can use that field to join instead of the...

I have an Access 2000 file that opens and runs fine with Access 2000, but when I try to open the file to look at the table or forms, Access 2003 crashes with in 5 seconds. It gives the VBE6.dll as the file that is causing the error. I have followed the instructions on the Access 2003 bug list...

I am listing records in a listbox using SQL in VBA code. I am needing to filter the records by a column that has the following values "Complete", "Rejected", "Transferred", "Working", "Hold", or could even be Null. What I want is to only display the records that are not Rejected or...

I have a continuous form and in one of my text boxes I am concatenating data from a one to many relationship to fit into one text box for display purposes only. I have that text box set up to show the data in a column style format. I am having to make the text box on the form long in order to...

Is it possible to display the data in an Access Page like a continuous form? I just want a read-only web page to show all records in the query like I would on a continuous form. I checked the properties and did not see anything that would allow me to do this. Thanks

I am a real new to the Oracle DBMS and I am having trouble creating queries, or SQL statements. I can build the queries using the Access Query views, but I am needing to be able to write SQL type statements as my application will be going to 20+ users and will be accessing the Oracle DB from VBA...

I have a form to select criteria (from and to dates, persons, depts) and am giving the user the option to select how they want the report to be sorted, either by a position(format like '018/A1') by drawing(format '1234567') or by date(format '4/19/2004'). All are Ascending. When I select sort by...

I am wanting to know when the data on the form has changed. I get Run-time error '2455', Invaild reference to the Dirty Property. I have use this before Dirty property with no problems, but that was on Bound forms, so I am wondering if it is different for UnBound forms and what do I need to...

I have posted this question over in the Access Project forum with no luck and thought I might have posted in the worng spot. Anyway, I have an Access Data Project that I am trying to help with (the original developer has left). The users are wanting to open a report to print based on the record...

I know how to do this with a .mdb, but seem to be having problems with .adp. I do not have access to the SQL server, so I can not modify any of the views or stored proc. I am wanting to open a report to print with the same record that is on my form. Usually I would use a query, but no access...

Does anyone know if you can get the MDAC and ADO versions of a users pc with VBA code? It seems that every user has something different on their machine (company not good at those types of updates). Thanks for any help Dave

My Access (2000) front-ends grow everytime they are opened and closed. I have checked to be sure I am closing all recordsets, and I am. I had a couple of users call me saying that their databases were not working anymore. I did a compact and repair and everything was fine. I know I can C&R...

I did a search and I am sure I am just missing the answer. How can you tab out of a sub-form back to the main form or a different sub-form without using Ctrl+Tab? TIA Dave

Hi all, I am getting ready to design a database to store EC Numbers that need to be worked, along with assigning a priority to that specific EC Number. In trying to make this as user friendly as possible, I need to be able to change the priority of an EC Number, and have the database re-number...

I am trying to figure this out. I know that I do not have a record, but I need the form to open with no error telling me I have no current record. The following is my code: ECR = Right(ECNum, 5) Set db = CurrentDb() Set rst = db.OpenRecordset("SELECT Field1, Field2 FROM PriorityModel WHERE...

I am not sure where to ask this question, so I am going to start here. I have Access 2000 and I am building a query to give me totals by section of airplane. Example Wing Detail Assembly Installations 2 3 5 Tail Detail Assembly Installation 3 5 6 I have set up the query total line to...

I have got a problem with a form. When you are in design view, you can re-size the window to how big the form will open. If the window is bigger than the actual form layout, the form opens with excess space. So I always resize my window in design view to match what my form layout is to avoid the...

I am trying to design a DB for the Boy Scouts to keep track of Camping Events and which Units showed up and how many were involved and amount if money collected. My thoughts are to have a table for the Event, UnitInfo, sbuUnitInfo, Camp, Doctor, and Payment. I want to be able to pull the...

I have a main form with a picture set as the background and I am trying to find away to have my sub-forms background be transparent so that the backround image of my main form can be seen. Is this possible? I have right-clicked the Detail section of the form and selected transparent from the...