Search results

I am building a database that will tell the company what items to dispatch to the customer first. It’s a food company. So getting products out on time is important. I will try explain it. Say the food company makes a batch of 30 apple tarts. This collection of products has a set batch number...

Hi Chaps I am having a problem with Access 2007. I have a hyperlink field that should take me to a web page related to the specific record I am in at the time. The problem is, they hyperlink won't work. As I move over the link the pointer changes to a finger as expected but when I click the...

This is a little complicated so I am not sure t can be done!!! I have a query that lists 40,000 records with some being sent to label printing The query breaks the records down so that any record with a Qty greater then 17 will be sent to a second query for a different label to be attached. I...

This might sound silly, but how do I create a database in SQL Server Express 2005 I downloaded and installed SQL Server Express 2005 (SQLEXPR_ADV.exe) from the MS website and installed it. On my start menu I have a folder called Microsoft SQL Server 2005 >Configuration Tools...

I’m not sure if this can be done in a query but here goes! I have two tables: Table1 Name Address City Table 2 Address County Hub Post via I then joined both these tables into one query. Query1 Name Address City County Hub Post via When a person enters information in the city field it...

I hope someone can help me. It’s a bit of a strange one. I have a query with information that I want to count. Here are the details. The query is for a reps database. At a given time the rep will change data in a dropdown box with 6 options to indicate what stage of the prospect he is at...

Hi I am trying to open a form that has 3 tabs on it. Each tab has a differant form. When I click the link on the main form, I would like the selected form to open and the Tabs to change to the selected subform. Link1>Form with Subforms>Tab 2 is open Link2>Form with Subforms>Tab 3 is open...

Hi I am trying to get access to close all open forms and open the selected form when a button is pressed. I tried this in a macro like so: open switchboard open new.client close (forms) The switchboard is used as a back drop to the database. the new client form will open over this (pop up...

I hope someone can help me. I have a form in my access 2003 database that I want to use for displaying small tables that would change at the click of a button. I want to use one form but when a person clicks on a button on the main form the table being shown changes to the selection the use...

I am not sure if this has been done in a table before. I have seen it in forms but not in tables. Here is my problem. I have created a database for a planespotters club. This database has the tables. ac_logged ac_maker ac_model country airport I am trying to display selected information in...

I am having problems printing labels in my Access 2003 database. The setting’s I have selected is L7161 and J8161. Both labels settings are missing the last row of labels. I have tried resizing the font to 8pt and changing the border size but nothing seems to work. I have a lot of L7161...

I am trying to build a table that lists aircraft viewed by plane spotters. In the “aircraft_spotted” table I have two look up wizards. The first lists the make of aircraft and the second lists the type. What I am trying to do is filter the models down to the maker. If I select Boeing I will...

I am trying to get a label report to print out a (P) or (F) on a label biased on the criteria True or False. I have a database that print’s labels for members in a club. Most members are paying members but there are some members that are free for a number of reasons. We need to identify the...

I am running an export Query but I need to count records and total there qty cell values. Its hard to explain what I mean so have a look below This is what I have Product QTY Paper 1 20 Paper 1 14 Paper 2 5 Paper 3 3 Paper 3 7 This is what I would like to happen...

I hope someone can help. I have a form that is based on a table and a second form that is based on a query. On the first form the person will enter information such as paper lenght and box's produced. When they click a button "Calculate" It takes them to a second form that will display the...

Can anyone help with my small problem. I have a simple form Based on a Query with: Invoice ID Customer Order Date Due Date Paid How do i get a record to apper red when the due date is passed and the order is still marked unpaid. If an order has not reached its due date it should stay black. ????

Can someone please please help. I am trying to print a report with a subreport But it just wont print. when i try to print it prints ever record. My next option is a size nine boot to the center of the screen.