Search results for query: *

I have a form with a subform. The form has project ID and other fields, the subform is for updating the progression of the project. So, if I need to update the project, I would go into the form and select new in the subform and it would give me a blank subform. However, there's a delivery date...

Please help me to insert multiple record in a single statement and what the max record I can insert in one statement. The below is what I been doing for inserting a as a signal record. Insert into emp123 (first, last, age)values ('Charles', 'Smith', 26); Thanks in advance

I have a form for project look-up base on a combo box that if you select the project id, another form display selected project. Within this form, user can update the project at the subform, in this there a "completed" check boxe, which that this project is completed. My question is, if...

I have a form with a subform that gets update pretty often. Within this subform there's a delivery date field that I would like to remains the same everytime the user click to get a new form to update. What I did was put the following code on the Default value from the event. However, this code...

When I updat a record from the subform by project ID. I would it to clone the last record with of the currect Project ID (not the last record in general of the table but depending on the last record for that project ID). I have tried to do the following, however it clone the last record of the...

I have a database that require a password. The user will not have the ability to go into the design mode of the database (database window is inactive for them). One user accidentally press the F11 key and the database window appeared. As an administrator, I press the SHIFT Key and Enter key in...

Does anyone know what is this error message "Internal Server Error 00-0003"? I get this message when I attempt to login a bank application via internet using Internet Explorer 5.5 as our browser. I think maybe this is setting problem but I have mirror the other computer in my office...

Just an general question, I also wanted to create a search form. Whereas you have a text field and a search button that can search for keywords or partial word base on what you entered in the text field. Then, the result would either found an exact match and bring up that record or could be...

I have a form with a subform. The subform is the updates of my projects which has a delivery date. However, when I add a new updates record on the subform, I like it to copy the previous updates delivery date field to my new update record, instead of having to retype it again. Any suggestion...

Is there anyway I can have my spreadsheet from excel share among my group, at least 5 people? Can they open the spreadsheet and update at once? Currently, I'm unable to have more than one user updating it. I would appreciate any help. Thanks in Advance

Does anyone know how to create a query that'll show me all records except a specified range? For example, I have a report that'll give me all project name, however, I what the report to eliminate a project name that start with "AES". Thanks

I need to run a query that'll show me all records accept anything that start with "AES". Can somebody help me on this? Thanks in advance.

I have a MS Date and time Picker control in a form. Default value always display current date (12/12/2002). How can I get rid of it. I tried to change from the "value" in the property, it automatically changed back to it's default. Can someone help on this one, my first time using this...

I have a main form (1st) that has a command button to open another form (2nd) for project lookup. The 1st form has a procedure to Maximize when opened. In the 2nd form when the user select the project from the combo box, the 1st form opened maximize with the desired record selected. However...

I have a text field for delivery date on a form that a user would type in the date, it is a required field (Is not Null). This field data type is Date/Time with a shortdate format. I currently doing some changes and created a Date and time picker (Active X), which is great. I went into the...

I have a macro that export my query to Excel, recently I been having problem running it. An alert box with the yellow exclaimation mark " Cannot Define Field more than once" any idea what's going on. Please help, thanks in advance.

I have a form called Update Existing Projecst, that will only allow addition, no Data entry or Deletion. This form has a drop down combox that allow the user to pull the specific record to be update. My problem is that everytime I first open the form, it default to the very first record with the...

I would like to disable the CTRL + F key in a form. The form already have a lookup field control of a Combo box. I would like the user to use that combo box to retreive a particular record. I don't want them to find any other field by pressing the CTRL + F key. Is that possible? Thank you

I have a form called Update Existing Projecst, that will only allow addition, no Data entry or Deletion. This form has a drop down combox that allow the user to pull the specific record to be update. My problem is that everytime I first open the form, it default to the very first record with the...

I have a form and there's a combox for lookup which can be pull each record up and the record's information would appear on the form. However, when the form is opened, the first record always appeared. How can I get a blank form when it's open and they can start to find the existing records only...