Search results

I have a query for a subform. I want the maximum number of records for the subform to be 7. I entered this number in the properties for the query but im still able to enter more records than this. Why is this? Appreciate any input. Thanks. John

Sean - Youre a saint! Thank you!

Hello, Im using Access 2K. All of a sudden one day, not doing anything out of the ordinary my combo/list box wizards dont automatically come up when I go to insert a combo box in a form. Im a wuss and create the combo boxes a lot quicker with the wizards. I unistalled and then reinstalled the...

I havent done anything new or differently than normal but I went to go into Design View in Access 2K for one of my forms and the box is missing on the left side next to the Form Heading Bar. The little box to select the form that is. Its not there for any of my forms. I tried doing a detect and...

Hello I have an inventory program that has a form and a subform. In the main form, there is the basic information. Part Number, Description, ect. In the Subform, there is the information on what qty was taken out on what day it was taken out and vice versa for putting items in stock. So for...

Hi I have a query to give me the part number and descriptions. I made a combo from that. So I have 2 columns. I set the Bound Column to 2. The widths are 2" and 2" and the Column Count to 2. It shows both columns when I drop down the list but after I make my selection only 1 of the columns is...

Is this a possiblity for a combo box? I have an inventory program that uses a part number and a description. I want to select a part number from the combo box and have the part number and description be entered in the same box. Or is there a way to join these two after they are selected? Thanks

Dude thanks man. Got it working again! j

Hello, I will try to include as much information as possible. I have a database with many forms and reports that are linked to the backend on a server. Whenever I want to add a form I build it outside of my current database then import the appropriate files to the front end and backend. I...

More Error Messages!! New Errors: Microsoft Visual Basic "Error accessing file. Network connection may have been lost." Then I click ok and Visual Basic Debugger Starts up. I have never received this error before. My network is all okay. Some of my forms are now opening and some now get...

I'll try the Me.Refresh for the button. That should work. I get zero messages when I try to import. I select my forms and click OK. Then the box closes and the forms are not imported. I have no idea why this isnt working. Ive done this a thousand times. I did do a repair. and still no results...

These seem like easy things to do and I have done them before with no problems but heres a couple things happening today. Im trying to insert a Refresh Button into a form by using the Button Wizard. Never had a problem doing this until today. Heres the error message I get after I click finish...

It is split. All the users use a local copy of the database thats linked to the backend on a Server.

I have a Database on a network with 5 computers. If a person filters a form to show only Part 200 record then if another person trys to enter data that is for Part 350 they cant because the records are filtered. Is this just a standard thing because of the filtering taking place?

I want to make a report with a query from a Form with a Subform in it. I built a query but my results are showing a duplicate of the top section of my form for every entry in the subform. If I simply right click the Form and "Save As" a report, I can get the report that way, but when I go to...

Yeah, Im finding out that its me, thats the big screw up? I'll try Newmans fix and see if I can cure this and then fix my forms so this doesnt happen anymore. Thanks

Hello, I have a basic form and it has an Autonumber to consectutively number my forms to provide an ID number. I was cruising along with no problems until today. Im on record number 247 and in the ID field it skipped to 248. Is there anyway to fix this. Its important that I have these numbers...

I ended up putting an unbound field in the form and a button to show the form that the number is entered. Seems to work good. This thing really isnt for me, but for our floor. They were used to doing something a certain way and do not like change. well...... Thanks for your input

Hello, I have existing records. 1102 of them to be precise. I updated the form that is used to enter the data for this and the new form is completely new. I was wondering if its possible to make a new form think its on 1103? What Ive done thus far is have my form with an Autonumber field at...

OH MY GOSH! Its always something. I had the code right but I had the > and < backwards so it was defeating its purpose. The Between Dates works, but I had a pop up form for the data entry. Between [Forms]![Data Entry]![Begin Date] And [Forms]![Data Entry]![End Date] THis works too. Thanks.