Search results

Hey Guys, Have been given great advice on this forum in the past- I would like to quickly clarify a table structure for a database I am working on. I appreciate those reading this invest some time in trying to visualize exactly what the person posting is trying to achieve so I will try to be...

Hi guys, I am trying to achieve the following- I want to query a table to see if a record exists with a particular field blank. If so, I would like to prompt the user for data. In real world terms, when assigning an item to a user I would like to first make sure that the item is not already...

Hey guys, Was wondering if anybody could help- I have a report which displays perfectly in Report and Print Preview modes but when I export to a pdf, the document width is clipped and does not show properly. Is this a known issue with a simple fix? I have googled and searched the forum but was...

Hi, I'm trying to achieve the following- ButtonA on MainForm to open FormA. When ButtonA is clicked, an inputbox prompts the user for a value and filters the records on FormA based on that value. I have a Select Case function on the On Open event of FormA, which inspects a field value on...

Hey guys, I have a couple of questions which I'm sure have simple answers- I'm just struggling to work it out myself. I would like to make a report consisting of multiple subreports. The main report is based on a query which has the following fields: JobNumber, EquipmentID, EquipmentType...

Hello, I am trying to figure out how to query data in my database based on a number of different criteria. I have reached a stage where I can get all the data I need from one query, however I can't figure out how to further query this data to return records from a table with the most recent...

Hello! I am creating an Access Database for work and through this forum, google and brief exposure to MS Access in college 7 years ago, I have managed to throw something together that I am reasonably happy with. I have now reached a stage where I could use some advice from more experienced...