Search results

Hi, I have had a quick look through these threads but can find nothing that gives me the answer I need. I have a Training Database with a Query that I need to identify/remove duplicates from. There are 35 employees (EMP_ID) with around 40 different procedures (Pro_Num). Each Procedure has at...

Hi, This is probably a really simple request but I have spent hours looking for a solution. I have a form with a combo box. The first column of the combo is captured on a table. There are other columns which I am displaying on the form as text boxes but I need the results of the text boxes on...

Hi All, I have a database that I need to print labels from. I want to be able to select an address and print a single label, any number of the same label or different addresses.. I have gleaned enough information from this and other forums to now have a form with a list of addresses with a...

Hi I have been looking through the forum for a solution to an inventory database problem but can't find anything that helps. I work with an inventory database that I produced a long time ago and it works well. Basically the stock is booked in onto a transaction table where I have the ability...

Hi Everyone, I hope someone can help I seem to be going round in circles at the moment. I am taking a value from one form into another. The value I am taking needs to select an item In a combo Box. So far I can move the value to the new form but cant seem to copy the value into the...

Hi, I cant seem to find anything that answers my question on the forum but I expect someone knows where I should have looked but here goes, I have a database that looks up files in a certain folder then as hyperlinks to that file and opens it. I can do that but the files I am looking at have...

Hi and thanks to anyone that reads this. The problem: I create a form from a table. It automatically inserts a subform from a linked table. Thats exactly what I want. But when I go into design view as I have done so may times before to take one of the fields out of the subform the subform...

Hi to everyone, I am building an inventory database for parts that go into producing a product. I have a parts table, goods in table and a goods out table. I also have a 'Transaction query' that takes goods in and subtracts goods out to produce a stock level. This is all very basic and works...

Good evening, I have seen a number of questions asking the same question but not one that fits my needs. I have a query that I need to select a number of criteria for. I have lots of parts that make up sets. I want to have a form with a list box that lists the set names. When one is selected...

Hello to all. I seem to have a problem with a Query that does not want to play ball !! I have a table with a primary key autonumber being the unique serial number for a form. I have made a query from this table using all the field from the table. In the customer field I want to exclude one of...

Hello to All. I have two problems which combine to make 1 big problem. 1. I am importing data from an Excel spreadsheet. One of the fields is a date field. But not just a date but a time as well. 30/04/2010 13:33:47. I dont need the time part. In my database I have a query which asks for a...

I have 2 tables linked by a one to many relationship. I have a number of queries and forms using this information. No Problem. I now go back to the tables one is OK the other has fields missing. Design view displays the missing field. Even the forms that use the 'missing' fields show the data...

Hi to all I have a query which I nee to select records from a certain date. I would like to use a 'date picker' control to select that date. I have looked through this form but can't find an answer. I have tried to use this in the criteria on the query ' [Forms]![Form1]![text0]' with a form...

Hi to all Can someone help or direct me in the right direction please ? I have a large table linked to an Excel spreadsheet with 30 or so columns. The Spreadsheet changes on a daily basis so the Access table also changes. No problems there. Where I am having problems is trying to get other...

Hi to all. This problem has possibly a very simple solution but I just cant get my head round it. I have looked through this forum but cant find anything to help. I have a linked table of data. This is then made into a query. It has a date column, which gives me the day of the orders. It has...

Hi to all. This might be a simple one but it is causing me a lot of grief! I have a linked table to a spreadsheet. The spreadsheet has dates in date-time format. When I make a query of the table in access and want to choose a certain date the time part of the data makes it impossible because the...