Search results

Every time I open my query based form it creates a new record in the file so that the next time I open it I get a duplicate record error. Is there a property I can set in the form or the query to stop the creation of the new record.

I have created a form based on a query that is used to enter and update information about a specific groupd of records. The user uses a combox box, also on the form, to enter criteria for the query. Once a value is entered into the combo box I attempt to requery the form but I keep getting an...

There is a field on my table that allows the user to enter a text description that varyies in size. When I try to associate a text box control with this field on my form it is not being diaplyed to the user and I am not really sure why. Can I set up a text box to display several Lines? Is...

I have a form that is based on a query. The way the query has been designed it should display one or more records concerning a criteria entered by the user. How can I set the form up to navigate through all the records returned by the query? In other words when ran independently the query...

The user id, call date, service date, and service description are on both the form and the service file. Once a user Id has been entered on the form(after Update) I would like to access the customer file to make sure the computer exist and if it does place the customers name on the service...

I have created a form used to enter data into a service log for PC repair. Once a pc users Id has been entered how do I use that Id to access a file not associated with my form in order to display information to the service personnel. What I am trying to do is find the users name in the...

I currently use a form to enter search criteria and am having trouble passing the value I enter into a textbox to my query. Everytime I press my search button it ask me for the parameter regardless of what I have entered in the textbox. How do I structure my query to accept the parameter from...

I have a listbox on my form that I want to fill and display based on the value entered in a text box. I wrote a query that gives me the correct date to display but when the form is selected I am prompted for the value before the form opens. How can I stop this from happening.

I have developed a make table query in order to create a back up table of some data. I nned to run this query on a regular basis and change the table name every time its ran. One time it is tabel2000 the next time its ran is table2001. Is ther a way I could pass the nre tables name to the...

The Database has been compacted, a stopmacro does exist, and the module has been recompiled. The macro consists of a opemmodule action that opens the follwing module. Private Sub runStateFile() On Error GoTo Err_runStateFile Dim stDocName As String DoCmd.OpenQuery "StateFile"...

I have an applicaiton that uses a query to create a file using the following structure DoCmd.OpenQuery "QueryName", acnormal,acedit The module is called from the switchboard using a macro. Whenver the module is called in this way it opens in debug mode and the user has to press F5 for the...

When I tried to apply this method i received an undefined user type error on the statment Dim dbs As Database

Thank You very much

Thank You very much

could you give me an example of how to use this command I cant sem to find much information regarding its use

I developed a make table querry used to build a report file. I open this query using a module that is activated or called using a macro from the switchboard. Every time I open the query it opens in debug mode and I or the user needs to press F5 fot it to run. Once F5 has been pressed it runs...

Graham T using your suggestion I keep getting run time error 2162 which tells me I have an error in my find record action argument. What exactly the error is I do not know and have not been able to find any information about. would you like to see a copy of my database so that you can see what...

Graham T using your suggestion I keep getting run time error 2162 which tells me I have an error in my find record action argument. What exactly the error is I do not know and have not been able to find any information about. would you like to see a copy of my database so that you can see what...

Please send me an example in A2K. Thank you

The tables used for this application are structured as follows: Student Student Id - Key FacultyId - Foregin Key Fac Table Major - Foregin key Major Table Minor - Firegin Key on Major Table etc. These files are queried and the results are used to produce the student...