Search results for query: *

We frequently have to retag computer equipment used by students. We have a SQL database that has a list of all asset numbers and associated serial numbers. With older units, we can scan the serial number to get the asset tag (and visa/versa). With the new units, when we scan the serial number...

I have a query that pulls in info for student netbooks. One model of netbooks has some units that are not under warranty. I am having trouble getting this query to work as needed. I know it's some silly syntax issue I can't see. The query returns results for all assets with one of 6...

I have a database that pulls from a SQL database, an IBM mainframe database, and the access database. I work for a large school corporation that separated one school into two separate locations this year. The information we for school location use is pulled from the SQL database which does not...

I have a form that creates a new record in a table with vba code. The code works and creates the record. However, I need to open a different form using ID of this new record, and I can't seem to get the form to open to that record. The table name where the record is created is tbl_RepairInfo...

I created a 2007 database (frontend and backend) that links to a SQL database and an AS400 database. There are some linked Access tables and a few local tables (in the frontend) that allows users to customize their environment. I have all the queries and forms local (in the frontend). This...