Search results for query: *

I have a form with some text boxes and one of them is for a Code Number (number datatype). The form also contains an Add New Record button. I’m trying to code the Code Number field to reject any duplicate numbers. Yes, I’m aware that there’s an option in the field table properties that will...

Hello, I’m working with a master form and subform. I have a closed button on the subform, because at times I want to only close or exit out of the subform while the master form remains opened. The problem I’m running into is that when I click the closed button on the subform, it also closes...

I’m working on a project in ms access 2007 that involves a main form and subform. The main form contains a record search textbook (txtFind) . I’m trying to search a record contained in the subform from the textbox on the main form, but keep getting the following error message: Run-time error...

Good afternoon, I’m currently working on a project that involves master and subforms. On the master form I’m using a combox to populate related data in the subform. Likewise on the master form, I’m also using a date textbox and command button to populate data in the subform based on a date...

I’m working on a project using a main form and subform. When the main form first opens, the subform will be invisible… On the main form I would like to use a textbox and command button to display filtered records in the subform based on a code number entered in the textbox, at which point the...

Hello I’m using a form that includes a text box and command button. I’m also working with adobe acrobat 7.0 pro that produces pdf files and also using Microsoft office document imaging that produces tiff files. I’m using a scanner to scan things such as maps and highway projects that displays...

Hello everyone, I’m sending this question out once again because I still haven’t been successful with my Main and sub form issues. I have a main form that has a text box for contract number. When keying in the contract number, after pressing the command button, I would like for the data...

I have a main form that includes a text box for entering a contract number. Once that number has been entered, I need the records associated with that number to appear in the subform. The problem I'm faced with, I'm not quite sure of the correct syntax to used to apply a filter to the subform...

Changing the variable from DBS to DAO fixed my problem and I want to thank you for that. May I ask one last favor of you and you shouldn’t hear anymore from me for a while after this request?. Is it possible for a text box control to function like a combo box? In one of my projects, I’m...

I Imported tables, queries, forms and reports from another database into a new database. In the new database I created a form that uses a text box that will search for records when entering a contract number. The problem I'm having is that once the command button has been clicked after...

I Imported tables, queries, forms and reports from another database into a new database. In the new database I created a form that uses a text box that will search for records when entering a contract number. The problem I’m having is that once the command button has been clicked after...

I need some assistance with a combo box I have a combo box that looks up the values in a table or query. I am using a main form with a subform. The combo box is on the main form. The combo box works fine other than when the main form first opens, I want all the fields in the subform to be...

I thought I'd try getting some assistance one last time before abandoning this project altogether. I have a data entry for that has various validation text boxes. I've placed the validation code in the BeforeUpdate Event as suggested, but still no luck. Ok, here's what I'm working with...

Here are a couple of problems I'm having with my data entry form and also with the Yes/No drop down field. Problem number one, I created a data entry form to enter and save data into the related table. Here are the field names for that form. LA Code Date Prepped Box Completed (Yes/No field)...

Here are a couple of problems I’m having with my data entry form and also with the Yes/No drop down field. Problem number one, I created a data entry form to enter and save data into the related table. Here are the field names for that form. LA Code Date Prepped Box Completed (Yes/No field)...

I’m working with the follwing text boxes on a data entry form. LA Code Date Prepped Box Completed (Yes/No field) Date_Completed Date_Incomplete The Date_Completed and Date_Incomplete text boxes are set to invisible until Yes or No has been select in the Box Completed drop down text box...

Hello once again, this is pretty much the same as what I sent last week in regards to searching a record(s) by date. I just realized that I failed to mention that the dates in which I was trying to use as a search are supposed to be Start Date and End Date as oppose to a single date. The code...

I'm working on a project in microsoft access 2000. I'm having an issue with Start and End Date manipulations. I'm trying to program the VBA code to display a message box if an incorrect Start and/or EndDate has been entered in the text boxes. Is there a way to do such a thing in access using...