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...

Oops ... if the AssetTypeID is 227754 and the InsSvcTag field is empty I get #Error ... if the AssetTypeID is 227754 and the InsSvcTag field is empty I get nothing

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...

Perfect! I doubt we'll be splitting a school like this again, as this was a very unique cirumstance. Generally if we add a new school we do pay to have a location added in our library database ... this particular school was already very small before it was split (it services a group of...

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...

At the end of this post is the original code (that works) for this button. It creates a record in a table, and opens a second form based on that info. When this form is filled out, techs print a bar-coded form of the info. We used to manually enter the ticket number into the form and I would...

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...