Search results

Hello, I am seeking a tip on how to add a function to my database. Currently I have a database to track materials for manufacturing. One table holds the raw materials and a different table holds the finished goods. Each has a different barcode indicator for example raw materials would look like...

Hello, I am working on a query that uses 3 combo boxes in a form to use as criteria in a query. As it is private data let’s say the combo boxes are “Model”, “color” and “size”. So far I have been about to query data if all three combo boxes are filled out correctly and matches a record. However...

As mentioned before on a different topic I am building a database to sort through publication authors. I currently have the table sorted in a way that only the main author is listed for the 3000 records. Now I need a way to remove duplicate entries on a new table. Each entry is a different...

Hello I am working on a new project database. This time I need to compile a list of authors from a excel file I have imported into a new database. I have all the data I need in my table, however I have run into small issue. I only want the main author to be queried from the author field...

I have a database that I created for the company I work for that keeps almost like a library check out system for our manufacturing materials. Each material is barcoded and cataloged with its information and this information is used though the office to look at our current inventories and item...

Solved! Outlook security warnings when sending e-mails from Access... I know that this is a problem that many people face, but I couldn't l find a way to solve it. I am running a database that keeps track of my companies chemical catalog. I just programed a new feature that allows a person to...

Hello I have created a database to keep track of chemicals for my company. Each bottle is labeled with a unique barcode that the database uses to search records. Even chemicals that are the same have different barcodes to keep track of quantities and location of each bottle. Also because of the...

I didn't want to revive the old help thread because that problem was solved however if you are not familiar with database you can find all the information on this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=232103&page=4 I was able to get all of the Status text to...

I am working on the order status formula for my Quote/order database. However I am not sure where I can use the If statement to do what I want. I have several yes/no boxes which depending on the status of the order will have different checked and unchecked boxes. The first IF statement is...

So I posted a question here about a debugging problem about a month ago with my database and never really got a solution. I am building a database very similar to a customer order database, except it also handles quotes for the company I work for. My problem is on the form where I...

So I have run into a small problem with my forms. I have combo boxes for customer addresses and shipping company for their order. After I select a customer the shipping address combo box updates to show only address under the customerID, however when I select an address it doesn’t update the...

So I am back for my seemingly weekly programing problem, I have the order confirmation form with a query subform showing the items in the order finally worki9ng however I have a new problem. On my original data entry from with a subform that appears as a datasheet to input the items for...

So a while back I created a database which I use to keep track of my companies large list of products. It is very simple only 3 tables, 1 query and 1 form. After running into a problem with copying and pasting updates on each computer in the office I decided to split the database on a network...

I am working on my chemical quote/order database and I realized I forgot to include some important data. Each product has 3 important details, “Core, surface and Generation” I have a barcode which tells the employees each of these bits of information using a different number. I was...

I am working on my quoting database and trying to make a confirmation window with the order number, customer name and shipping address which the user would have filled out in the previous form. It is a popup form that should show the currently opened order forms data. So far I have the combo box...

I am continuing to work on my quoting database. In case you not aware of my database, I am designing a very ambitious database for the start-up company I work for. We manufacture specialty chemicals for research and the database I am designing is supposed to track a customer’s quotes and orders...

Hello I am relatively new to programing MS Access Databases and I designing a very ambitious (for me at least) new database for the startup company I work for. We manufacture specialty chemicals for research and the database I am designing is supposed to track a customer’s quotes and orders. So...