Search results for query: *

I'm trying to figure out how many trucks we have had come into this facility in the last 24, 48, and 72 hours. I have a Date/Time Field with data showing 1/10/2005 6:00:00 AM What do I put in the criteria to look back a certain amount of hours? Thanks for the help. Jason Alge...

I have a command button that imports text into a table. The code is called Import_New_File_Click (). I'm trying to get that code to run from a macro but I'm not sure how. I copied that code into a module and saved it as Module 1. I can't get the runcode in the Macro to run this module...

I have a table with one of the Fields containing the Date/Time. I'm running a query where I only need the Date pulled out. The way that it's been working has been with this string ADDED_DATE: Min(DateValue(Mid$([caroship table]![added_date],1,10))) I'm unsure why but I keep getting a Data...

I am having problems with a query that has been used for quite sometime now. The query should never have been changed because it runs off of a command button on a form. Anyway, what I am having problems with is this line... ADDED_DATE: Min(DateValue(Mid$([caroship table]![added_date],1,10)))...

Hey all. We have a database that we use to import text files. The naming convention of the text files are as such: January 4th, 2005 would be created as 20050104.txt These files import into a database. The files are created only if there is activity going on, so on Christmas and New Years...

I've built a Union Query that pulls counts from 3 different queries. I placed those 3 counts on a report but my boss wants the percentages beside it too. The output is this Building Picks 130000 Mod 13000 Perms 5000 I need the percentages of the picks that are...

Hey all, I'm trying to set up a Union Query and I've got a couple of questions for that. First of all, all three queries are doing a Count of something different. So my series of questions are this... Can you set up a Union Query if all 3 Field Names are different? If so, how? If not, how...

Hey all. I've got 3 queries that I'm trying to put together into 1 report. All I want is to be able to add 3 text boxes to a report and make the control source of each text box = the Field in the query. I tried to use the expression builder but that is giving me a #Name? Does anyone know...

Hey all. I have 3 tables that have 1 cell of information in them. It's a total put together from a query. I'm trying to find a way to get them onto a report but I'm having problems. The control source for each text box keeps coming back with errors. I've tried to use the expression...

Hey all, I'm building a query for a Cycle Counter to sort through pick zones. He wants a query that you can use to remove Pick Zones that are scheduled. There are over 30 zones, if there are 3 scheduled, he wants to be able to type in the 3 zones that are scheduled, to show him all of the...

I wrote a script that restores all files on each volume group and appends it to a file. This way you can view what was restored on last night's tape. We ran this over and over and discovered that the restore process wasn't stopping, so there were hundreds of process hanging out there. I'm...

I have a form on a database that keeps track of work orders. Once a week our tech comes in to fix our Scan Guns and we enter the fix date on the work order. Every Monday my boss wants to run a query to see how many guns were fixed on the most recent date. The tech doesn't come in on the same...

We're trying to open a very important Database that we use everday at our facility but it is giving an error Microsoft Jet Engine could not find object "MsysDB". Does anyone know how to go in an repair this database or does it have to be restored? Thanks a lot. Jason Alge...

I'm trying to import a bunch of tables into access using a marco. This will be done as an autoexec when everything it completed. Anyway, the files are called wavelog20040410 (YYYYMMDD) These are files brought over from our RS6000 weekly. Anyway, I'm trying to import them all into 1 table, and...

Hi all. I'm developing a Web Page for my church. We made a banner on the top with a background color of blue. The background color of the rest of the page is brown. Around the banner at the top, there is a brown border and we don't like it. We want the banner to be positioned in the very...

Hey all. I've got a combo box showing part numbers and descriptions. Beside the combo box is a text box. I'm trying to select something out of the combo box and have the part number stay in the combo box and the description show up in the text box. I have two tables dealing with this, my...

I have a command button that imports .txt files into a database. The text files show all of the activity in the building. If there is no activity, then no text file is created. We run this command button to import that data into a table in a database. The problem is, when there is no text...

Hi all. Gotta question. I'm using dlookup to return information in a table. The information is coming from the Inventory table. When I select a part description in a combo box, I want the part number displayed in the text box. The dlookup string that I have is this...

Hey all. I've got a table that has 3 different fields. The three fields are Part Number, Description, and Qty on Hand. I'm trying to make a form that has a combo box and 2 text boxes in it. What I want the user to be able to do is to select which part they are sending back with the combo...

I've got a report that prints badge id's for users in our facility. There are two sides to the badge. The front is the picture and banner, and the back side is the information and barcode. The back side on the report is longer left to right. I know there is an active X control that allows...