Search results

Okay I've searched the forum and have not found exactly what I'm looking for. I'm trying to create a query to show me records for a given year. The issue I'm having is that each record has (4) dates fields and each record can contain null values. Is it possible to do this in a query with...

I have created a query the gives me a supplier number and the supplier name. I want to use a combo box on a form to select the supplier number and be able to see the supplier name in a text field and store the information in a table. Can this be done?

Is there away to join the attached 3 queries (Q-Scrap_Not_Recorded_2_Cav_Molds, Q-Scrap_Not_Recorded_4_Cav_Molds, Q-Scrap_Not_Recorded_8_Cav_Molds)? I need a single report or query that will give me the "scrap not recorded" based on the "shift code" and "process group" fields. I can run them...

I have several reports that I can't print because my toolbar that I created and put into the report properties section does not open up with the report like all my other ones. These reports all have a common difference. These reports are activated from a form where some criteria is selected...

I have created two reports that I open after a shift code is selected from a combo box on a form. I want the selection form to close after opening the report so I wrote in a do command close in the command button but now the reports don't open properly. Anyone have any suggestions? Thanks, Jerry

I have a report that is filtered by choosing a number from a combo box on a form then a command button opens the form and hides the form. But the report opens up behind the switch board. Anybody have any idea why this particular report does this? My comand button code is below: Private Sub...

I'm trying to use a slection form (F-Select_Shift_Code) to select a date code from a combo box and open a report to show only the criteria slected in the combo box. I've tried variouse ways to do this and can't get it to work. Can some one see why this isn't working please.

I'm having trouble with my vacation tracker database. The allotted vacation time keeps defaulting to 160 hours. If I open the "add/edit employees form from the main menu and click on details, it changes the allotted hours from what I had back to 160. Any help is appreciated.

My computer crashed and I lost my employee vacation tracking database. Does anyone have an Excel spreadsheet or other tracking method they could share please? I really don't have time to build a new database. Thank you for your help.

I have to complete a form for my customer that is currently in Excel. The form is very cumbersome to use plus I have to maintain records and trends on the data. I have to use there layout. Is there a way that I can use Access as the data entry and export the information into a Word or Excel...

I want to create a report that looks exactly like one of my customer’s forms. I have created the table and data input form, now is it possible to create a report that would include my option list results and the check boxes too. See attached screen shot for example. Jerry

Is there a way to link a combo box to other fields? I have a form that data is entered into and I want to have a default value place in a field based on a selection made in a combo box. Example: Combo box choices: "Owner Reservation", "VBRO Reservation", and "Dunes" I want my one of my form...

I'm having a small issue with a form/calendar I'm working. When I enter the "unit name" in my "F-Add Reservation" form. It is putting the unit name in twice on the departure date of the "F-Reservation Calendar" form. I changed some code and now I can't figure out what I did to get this????

I'm having a small issue with a form/calendar I'm working. When I enter the "unit name" in my "F-Add Reservation" form. It is putting the unit name in twice on the departure date of the "F-Reservation Calendar" form. I changed some code and now I can't figure out what I did to get this????

I have a calendar that I have tried to modify for my vacation property database. I'm trying to add reservation information in a form to update a calendar so I can see availability but I'm getting run time errors and my calendar is not displaying the information. I found a lot of the code...

I have created an option group on a form. Is there a way to change the check boxes so they toggle on and off?

I have searched the forum and have not found what I'm looking for. I have created a vacation property rental database and I need a calendar to show available dates (see attachment). I would like to pick the date range on a calendar and just have a monthly view that the date would change color...

I have a data input field (memo style) on a form. I would like to be able to use a return (enter) to go to another line for numbering. Example: 1. Test results 2. Report Results 3. So on I can not figure out how to do this. The text wraps but I can't seem to add my own spaces.

I have a data entry memo field on a form and I want to add a spell check feature, how is this accomplished?

Is it possible to take a number in a main form (stored in a table) and subtract a number in sub form (stored in a separate table) and if so how would you do it? I've tried a couple of ways and have had no success. Jerry