Search results

I have a table with a list of my customers and a form for entering price quotes for each customer. When I enter the customerID in the form, I would like to select the customer from a drop down list rather than have to remember the customer id every time I enter a price. I am a novice to access...

I have created a switchboard for an inventory data base. I would like to add a control to the switchboard where I can look up an inventory item in my data base by clicking it and it opening an imput box for me. Any idea as to how I can or if I can do this. Thanks Darrell

When I print reports a blank page prints between every page. Any ideas as to how I can fix this. Thanks darrell

I have an inventory transaction file that has quantity on hand as a calculated field. I am trying to add this unbound field to a report using a query but I can't figure out how to add my quantity on hand field to the query since it is a calculated field and not a bound control. Any help would...

I have an inventory transaction file that has quantity on hand as a calculated field. I am trying to add this unbound field to a report using a query but I can't figure out how to add my quantity on hand field to the query since it is a calculated field and not a bound control. Any help would...

I have an inventory form which has a subform for inventory transactions. When I fill up the form on the page I would like to be able to scroll up and down to view records that have moved off of the screen area. Is it possible to add a scroll bar to this subform and if so how. Thanks darrellx

I have an inventory form which has a subform for inventory transactions. When I fill up the form on the page I would like to be able to scroll up and down to view records that have moved off of the screen area. Is it possible to add a scroll bar to this subform and if so how. Thanks darrellx

I am trying to build an inventory report and am having problems. I have a field for units on hand which is a calculated field in an unbound control on my form. When trying to add fields to my report with the report wizard, I don/t see this control anywhere to add it to the report. How can I...

I have an unbound control in a form that I have set up to allow me to choose between cash or credit. However if I choose one or the other it automatically puts it in all records. I have added a field in one of my tables where it allows for me to choose cash or credit, but I can't figure out...

I have created a subform in an expense account database and have inserted an unbound control to distinguish between a "Cash" or "Credit" expense item. I have made the control a combo box and in the properties, I have made the Row Source Type a Value List, and in the Row Source line, I have put...

In the design view of a form, how can I find out what table or query data in coming from in a specific control? Thanks Darrellx

When typing a date in the date field is there a way to keep from having to type in the / between month/day/year and have access automatically convert it to that format? That would simplify things a lot. Thanks; Darrellx

I am trying to make a one to many relationship in from my product table, productid record to my tblRel table, productid record and it will only create a one to one. What am I doing wrong? File is attached for reviewing. Thanks Darrell

I have created a very simple inventory program just to keep track of items in stock. I created a subform for inventory transactions within a product form. When I try to input a second transaction for a particular product id I get the following message: The changes you requested to the table...

I have built a very simple inventroy tracking program and am having a problem with the form and subform. I am trying to update my Units on Hand with a subform but can not figure out how to make the subform record advance to a new record when I enter data in it. For example I enter a new item...

I have just created a very simple inventory tracking program and as a total novice I am having problems calculating my Units on Hand field. Attached is a copy of the file. If anyone could give me any pointers I would greatly appreciate it. Thanks darrell

I am a new access user and need some help. I have created an auto fill query to fill in information on a sales order table from my customer table based on CustomerID. I have also created a sales order form. When I enter the customer ID in the form the rest of the data does not fill in...