Search results

I've got a database that I need to import a vacation days table from an excel sheet. The biggest deal with it all is that the excel file & range it needs to search for the data is dynamic, actually I also need to be able to scan different sheets within the excel file. Now, im not new to all...

I have a query, it joins a local table to a remote table (Oracle Database Table) which makes it slow(ish). When I am in design mode and i click the "View Datalist" button, which visually shows me the results, the query executes in about 12 seconds. When I use the "!" Button to physically...

Is there a way to generate 2-3 reports and append them together into one preview, or perhaps export them to one Word File? This would help for generating multiple graphs in reports for a large set of data.

Is there a way to generate more than one report and have it appear as one in preview?

Can someone tell me why when i break on this line, it reports rst("MechHours") is 800 If rst("MechHours") <> Null Then But branches to the else block?

K, this is sorta a duplicate, but with a twist. Building a combo box to select an item. but it needs to hold the ID as it's value, but display the name. I can get the value to be hidden in the drop downs, but i want the resulting field to display the NAME, not the ID. How can I do this?

I have a split DB setup (you know, Front end and back end) that's used throughout the maintenance dept. here. My Backend DB is locked up with your simple Startup stuff (nothing too killer) buy just enough to keep the computer illiterate out of it so they wont mess it up. Im looking for a way...

What kind of security problems have versions of access encountered with the new SP2? For I noticed a lot of programs have been having issues recently. Just havent played with office yet, I presume that it's all good because it's all made my Micro$oft, but you never know... Just let me know...

Im sure it's a bit duplicated, but i cannot find the specific answer to my problem. This database, even though i've bypassed with the SHIFT key, has NO sequrity file, but I cannot modify the design. Cannot import, link, or use anything that involves modifying/creating in it, cannot even convert...

What are all the requirements for a query to remain updatable?

Trying to pull up records that have any scheduled day/time in another range of date/times. Ok: In my Table i have Scheduled Start and Scheduled Finish, and on my form i have Period Beginning and Period Ending. I need to pull up any records that are scheduled to be active between Preriod...

Is there a way in VBA to get the current record number, i cannot seem to find a property in the form, nor an answer in the search on the fourm.

I have text boxes set togrow if needed in my page header, but the header will not grow to account for larger text boxes... any ideas?

How many of you have been programming and needed a simple two way conditional aka if blah = blah then ..... else ..... end if, where one way does some less relavant code, and sometimes wondering how you should structure you're logic (aka, where relavant code should be...) I recently conducted a...

Appending Bits to a String (And now more questions) I need to add bits onto the end of a string... can anyone help me?

Can different items be coloured differently?

Here's the background: I've got a question, ive developed a split database here for a virtual tour project. It allows the vets here at the plant to sit down and enter in information on all the equipment in the plant (aka. populate my database). To facilitate a multiple computer environment...