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...

How would i get that information into a text field if i didn't use dlookups ?

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...

Is there a way to do this but send the query into a excel template instead ? I'm putting a reporting feature into an access database, however visually the data can be displayed better within excel so i'm planning on creating a template that i can export the data from Access then save it with a...

Hi Ranman256, Thanks for the reply. So i create a macro, add each query i want to export (exportwithformatting), could you explain the last parameter bit please ? i'm looking at the macro but i'm confused as to where you mean. Thanks for your help so far!

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 Ranman256, Thanks for getting back to me!. So would i have to do an individual query for each hour block in Q1 ?

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 arnelgp, Thanks for your help so far but unfortunately the code performs the same, it opens excel but it still just flashes in the task bar until you click on it. Any other suggestions ?, such a frustrating problem! Thanks once again for taking the time to help arnelgp.

Hi all, thanks for your suggestions but I've had no success so far. Ranman256, when i try your suggestion it just minimises one dialog box i have another still open as well as Access. JHB, Your suggestion pulls up an error stating the the object does not support this property or method...

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, First off thanks for the reply, it's appreciated. I've tried searching the forums but i can't find anything specific to what i'm trying to do, Do you have a thread in mind that is similar to the problems i face ? Thanks!

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 CJ_London, Thanks for taking the time to reply I'll try to be more detailed. I have a small number of text boxes and drop downs which require the user to input specific information relating to a container risk rating. depending on the input information i have a code running in the...

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...

Apologies for the etiquette error. a bit of a novice. :-S Secondly thanks for taking the time to reply. I can see i have a lot to work on :-). I'm going to have a go at some of the suggestions you've brought up. Once again thanks. Greatly appreciated.

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...