Search results

Thanks for the great feedback Lightwave. I am going to have a chat with a couple of people at work, see what they think, and see if I can get a copy of A2013. I know our database has been plugged in to A2013 already - though I haven't done it first hand, and there were some functionality issues...

Hello Everyone, I am hoping for some advice about upgrades. I am a Power IW, and its been a couple of years since I've done any developing with Access. My company has tasked me with doing research on what to do moving forward with Access since we are upgrading machines (thankfully we will be...

Hi, its been a about a year since I've worked on database design, but my employer has a database that was created by a previous employee around 5 years ago and it needs some redesign. I've searched to see if I can find anyone with a similar problem, but haven't had any luck so I thought I would...

Hello everyone, I am having a compatibility issue with my database that seems to be stemming from my report queries. I am using Access 2007 and have a database that is saved in 2000 compatibility mode. The interface needs to be in both Access 2007 and Access 2003. When I open the 2000 version...

Thank you!! Problem solved! I did try using parameters once before, but I guess I never tried it in conjunction with the Like wildcard statement. Thanks a million Bob.

Thanks for the input, but I don't actually want to convert the data format in the table. It already is formatted as a (general) date, and the Visual CE program records the full date/time (information that my client wants recorded). That means that without using Like [Enter Date:] & "*" as my...

Hi there, I have a form with its underlying query built from a table. Users access this form by entering a date when prompted. I am having trouble fine tuning the criteria to prompt for the date because underlying field in the table is date/time (general date) - formatted like this: i.e...

Sweet! Thank you, that was so simple and exactly what I was looking for...

Hi All, I have a question about adding a specific message box to my code. When users click a button on a form, a dialog box (using the FileDialog filepicker) allows users to select multiple excel files to import into a table. The file picker stores those file names and then...

Answer: OLE Error with Embedding Excel Sheet Well I took a copy of the database I am working on home and tried to embedd an ole object on a couple of computers - I was a bit suprised to find that I was still not able to embedd the OLE object, especially since some of my coworkers seemed to have...

I just recently started getting the dreaded OLE object operation failed error message. I am using Access 2007 with Windows XP Pro. The operation on the OLE object failed. The OLE server may not be registered. To register the OLE server, reinstall it. This error is occurring when I attempt to...

Thanks! The Force New Page property was set to 'none' - but I noticed there is also a Keep Together property which was set to 'yes' - changing this setting solved my problem :D!

Well, I think the setting should be do not keep group together on one page - so that it shows as many records will fit at the bottom of the first page with the group header. It is still bumping the details down to the next page....

Hello, I am using Access 2007 and I have a report with one group header and details. I want the group header and details to show on the same page (and let more details run on to the next page), but it when I print preview all the details are pushed to the next page and it leaves a big blank...

Here is my report with a subreport. You enter the dataset Id in the main report and it automatically pulls up the daily logs within the date range of the dataset Id. If anyone is interested to see how it works...

Hi, It wasn't showing anything when I viewed the query for the main report - but I did manage to get the thing to work. I had a coworker copy my report to his pc and it worked - we were puzzled for a couple of days trying to figure out why and finally realized that the problem was related to...

Thanks anyway dkinley - it doesn't seem like any of the examples on that website are doing what I am looking for...

I need all the associated records from the subform to show up on the main report without having to force the user to enter the Start_Time and End_Time. I've tried a few more things - and now it will show just the record with the last applicable date when before it would show no records at all...

Hi all, I have a report with one subreport. The main report has 2 controls (one for Start_Time and the other for End_Time) and the criteria asks for Dataset_ID. I need the criteria in the subreport to pick up the Start_Time and End_Time and display records between these dates for the user...

Hi, I'm new to the forum and I found this thread which is exactly what I wanted. I downloaded the sample DB you posted and modified the module to work with my tables and query. However, when I tested it out I noticed that the concatenation is dropping the last entry. I tried a few things to...