Summary: I am writing a point of sale program in Access 2007 and need to include a way of firing a cash drawer from the program. As I haven't obtained the draw...
Summary: I have created a time card database that calculates total hours. Also, I have two tables employees and time cards. In the employee table all of their...
Summary: Does anyone know how to get check boxes to work in a query where there are two tables joined? For some reason the check boxes don’t work when there ...
Summary: I solved this problem when using Access 2003 by exporting data into Excel but having upgraded to Access 2007 where this is not possible, I’m trying ...
Summary: Thank you, mendo! I compacted my db and it fixed my switchboard. Also saved a good amount of disk space! I never would've guessed that Access coul...
Summary: Good Day I have an Access 2007 database that contains a main storeroom table wjth records as follows Code, Name, Qty, Unit Price, Total, Type My quest...
Summary: My database became corrupt. When trying to open a form, Access locks up. When trying to open the table for that form, I get the following message; "Co...
Summary: hi there, I am new to access and trying to create a database to keep track of my working hours and wages. I have a table with a field called "reg hour...
Summary: i am a non-professional user of MS Access for the last 8 years and through playing, eperimenting and searching i can say that have become pretty good ...
Summary: Get this error whenever I try to print preview in Access 2007: There isn't enough free memory to update the display. Close unneeded programs and try a...
Summary: Just did a search on Access 2003 and found several sites that are selling it for over $600. Why is so expensive to compared to Access 2007, which is s...
Summary: I was editing some forms in Access (Access 2007). I added a product into the switchboard manager. My default is selected to what it always has been ...
Summary: I have an Access 2007 database issue. I need to add the values from the laboratory results for two chemical compounds: m, p-Xylenes and o-Xylenes (e...
Summary: I have a table in Access 2007 that has all fields as Text. However, some of the fields on older tables have a mix of Text, Date/Time, Yes/No, and Num...
Summary: I'm trying to figure out how to get Access 2007 to fill in one field based on what is put in another field. Specifically, I want a Region field to fil...
Summary: I am building a database in Access 2007. 2 of my forms are "Salesman" and "Client". 1 salesman has many clients but 1 client can only have one sale...
Summary: I have a table of postcodes in an access 2007 database and I need to isolate the first part of the postcode. Does anyone here know how I can calculat...
Summary: I have read a few of the responses here, and am impressed with the replies. In that regard I'd like to ask this question. I am attempting to implemen...
Summary: I am working on a Microsoft Access project and need a validation rule for the job number. I need it in the form 09-140 where the 09 represents the cur...
Summary: I have created an MS Access db, 2 of the fields relate to time...StartTime & EndTime. From this I have created a query to display the attendance time...
Summary: Hi, I'm having an issue trying to match up records I have in an Access table. Each time I append the data to the table, it creates duplicates. It does...
Summary: I have an issue that seems like it could be resolved by sql code or query. I have a simple, one table access database (contactfirstname, contactlastna...
Summary: Hi, I am using Access 2002 to create a report. I have the following fields: Field 1: shows the cost of the item Field 2: displays the price paid. ...
Summary: Im trying to implement a function in Access 2003 to allow the application to find a given field from a give another field in the same record. e.g. I h...
Summary: Is there a shortcut key in MS Access 2000 for adding a new record? I haven't found one, and when I want to add new record in form view, I have to clic...