Search results

Good morning, I'm having trouble with what I think should be a simple query but I'm pulling my hair out. All I need is employees by month. January for example. Shouldn't I be able to query employees who have a null term date and hire date prior to 1/31/20? Thanks in advance!

Good morning. I'm trying to create some employee statistical reports and for some reason I can't wrap my head around how to make it happen. For example: I need the average monthly employees for any given month. My CFO does wants the number each day and then the average so he can have the...

Hello all, I am working on whichever version of Access comes with 365 (I can't seem to find the version). I have a form based on a query to enter employee time. I have a field for hours and a drop-down box for earnings codes in the form detail. In the form footer, I need to total the...

Good morning, I am running Access with Office 365. I have continuous form based on a query for job applicants. The form has first name, last name, date applied, applied for, etc. How do I set it so that the columns on the form can be sorted by the user. Many years ago, I had a database I...

Hi all! I have a form with 2 combo boxes for zip codes. I have it so that when you add a new zip it updates the table and re-queries both boxes. The problem I have is that I have a sub-form with a zip code combo box on it that also needs to be re-queried on update. I'm having trouble finding...

Hello again! I have a form that I created a combo box and cascading combo box on. The combo box is our customer list. The cascading combo box has parts by customer. These are working fine however, I need to find a record based on the parts selected. I tried adding a combo box that finds a...

Good afternoon, I've searched the forum and I know this has come up but I'm having trouble finding exactly what I need. My apologies if I am searching the wrong thing. I have a primary key/auto number field that I need to format as the year and number. For example - 18-00000. Each year it...

Good afternoon all, I need a little help. I'm trying to set a combo box with cities in it so that users can add data, it will check for duplicates and refresh itself. I'm on Access 2016. Is there any way to do this? Thanks in advance for your help.

Hello all. I have a quick question. Is there a way to set user levels in access? Thanks in advance.

PLEASE HELP!!! Boss getting on my case HARD! I am having a MAJOR problem with the new database I wrote. I have several forms in the database that merge with word and spit out customer special reports, etc. On my machine it works GREAT! I am running Windows 2000 and the code I am using is...

My new db up and running but I have a couple of issues that have come up as well as a new report I am trying to program. I was wondering if anyone can help. The db was built in Access 2000 on a Win2000 machine. Three of the machines here are running XP with Access 2003. I asked one of these...

1) When XP users open the database it gives them some security warning because of the macros. Does anyone know how to fix that? 2) When merging w/word it works great for me but on some machines, it simply opens word and nothing happens. YIPES!

I have a report with 2 subreports. One which should print on each page of each record with the same header/footer. I am printing work orders and one has the information for the shop minus any accounting figures and the other is the same but contains dollar amounts. This works fine when...

My database here at the office is FINALLY up and running minus a few little kinks to be worked out. The first one has to do with time cards. Our employees may work 14 hours in one day and it is broken out on the time cards and by job as 8 regular hours and 6 overtime hours however, at the end...

I set up a button that merged fields with a report in word containing bookmarks several weeks ago. It works GREAT! I need to do it again and I have the event procedure...I just can't figure out what kind of button I used to set it up. I am using the wizard and I forgot how I did it...I think...

I have a query from two tables. Table A has WorkOrderID CustomerID CarInitialID CarNumber TrailerNumber etc... Table B has CarInitialID CarInitial Since I the WORKORDERS table saves the CarInitialID as a number, I have created a query to use to display the data on top of forms. I have a...

I am so new to Access and learning so much but this one VERY SIMPLE little thing is making me nuts! I have a table WORKORDERS set up in my database. For example it has: WORKORDERS WORKORDERID (primary key) CUSTOMERID PURCHASEORDERNO CARINITIALID CARNUMBER Some of these values (IE...

I need to print a report of all of the cars in our facility at a certain time and have created the query. The problem is I need it to take the data and if let's say the list is longer than 3" of the page on the report, I need it to throw it into columns so that it all prints in the middle of...

I have a form from a query for Spark Test reports. The query contains the job number, the customer, car number, etc. for a particular job. I have the form done in Word and have tried to merge the data source but when I click on the datasource in Word the Spark Test Query is not listed for some...

Is there any way to set a checkbox on a form so that if for example there is a car number in the car number field the default value is true?