Search results

Hi all, I've been struggling to get a wildcard to work when trying to open a pdf within a web browser. I've pasted the code below i'm just trying to prove the concept before implementing it into the proper database so excuse the lack of a naming convention :-) WebBrowser20.Object.Navigate...

Hi Everyone, I have a query that works by looking at a form and returning the data back into a listbox, All was going well until i needed an expression that would show all if a text box was null, however if the text box was populated it would then show all the figures that were between two...

Hi everyone, I have a form that displays certain data input throughout the day so management can see how the machine is performing, however they requested to see some information that has resulted in another 24 text boxes being added to the form all with dlookup's in the control source. As you...

Hi Everyone, I'm looking to export several queries into separate excel sheets (within the same document) on the click of a button within Access. I'm struggling because the Docmd.outputTo and Docmd.outputTo commands will only let me export one at a time. This is a problem because i new file is...

Hi everyone, I'm stuck on a query and wondered if you guys may be able to help. Basically we log efficiency manually and it is meant to be done every hour. I want to list the data in a query so that if the efficiency is logged at 9.47am it will show up like the example i've mocked up below...

Hi Everyone, I'm having some issues with my list boxes at the minute and i wondered if anyone could help. I have a form that refreshes every second, i also have a list box on that form that requeries on the timer (every second) this works fine most of the time but users (who are using the...

Hi Everyone, I've hit a brick wall when trying to open excel from access and bring it to the front. I've managed to do the first part with the code below but the Excel document is opening behind access and i need it to come to the front. Does anybody have any idea's on how to rectify this...

Hi All, I've got a problem with a query i am working on at the minute and i can't seem to find the answer. I am creating a query that looks at data collected from staff working the night shift. They start at 6pm every day and finish at 6am the following day. I'm looking for an expression that...

Hi everyone, I'm currently creating a calculator where selecting from several drop down menu's calculates a figure (basically a nz function) which in turn , depending on the calculation allocates the project as a low risk, medium risk or high risk. If the user selects certain features from the...

Hi, i'm currently trying to display a date on a form via a dlookup but i'm comming across some issues. The query's name is PRISM_SAMPLEDATE The field with information i want to display on my form is PLANNEDSTARTDATE and i want it to relate to my form (Design_Detail_ProjectManagement) to the...

Hi Guys, I wonder if you may be able to help me as I'm stumped as to how to solve / work around this one. I have a query that i use to update dates relating to jobs and at what stage of development they are in. It worked fine until I started to pull in some data (Prism) to help update the user...

Hi all, I'm having an issue at the moment with list boxes and if anyone would be able to cast their eyes over this I'd be eternally grateful!. Essentially I have a form_A with several tab's and then one list control box in each of those tabs. At present if you double click on any item within...

Hi Everyone, I'm basically having issues with a query and in turn a list box displaying duplicate records and I've tried everything within my knowledge to make it work but I'm at a loss as to what else i can try at present. I am trying to run a query that shows the job number once as well as...

Morning all. I'm trying to create a query that will return the closest matches to what is input. However the closest i have gotten to this working correctly is by using the following criteria. Like Left([Forms]![TESTTESTTEST]![Text2],1) & "*" Now obviously this isn't a great solution as it...

Hi Guys, Could anyone offer me some assistance with relationships between tables please?, Apologies if this is a stupid question but I have a job number (4 digit number) which is currently set to auto number in table 1(container) I need this number to automatically update throughout the other...

Hi Guys, Basically i have a list control box which displays data from a query. I have a macro which opens up another form when a record is double clicked in the list control box and theoretically it should display that record, however it is currently only displaying the first record in the...