Search results

I've spent a good bit of time trying to solve this one. My previous chain of events to get a filtered report, view it and then export it: Command button on frmMain opens frmDatePicker > User enters date in frmDatePicker.txtDate > Command button on frmDatePicker opens rptWatchLog in...

I have a report that is opened via a Form that lets the user choose a date to filter the report. The report opens in Print Preview mode. What I'm attempting is to give the user an easy way to export the report once they've verified the report is accurate. One way I've tried to do this was to...

That's precisely what was happening. Calculated fields in tables are supported in Access 2010 (and 2013, I presume), but not in 2007 and earlier version. I'm developing using 2010 and my users are using 2007, thus the incompatibility. However, once I removed the calculated field from the...

Importing everything to a new database solved the error. Thanks for the suggestion. Follow up question about object dependencies: One thing I noticed after creating the new query was that on the object dependencies (objects that depend on me) for the original table, it still lists all tables...

Yep, the field is gone. Verified in datasheet and design view. I've also attempted Compact and Repair with no joy. I'll give the import a try. I'm assuming the intent is to open a new (and empty) database and use the import tool on the External Data tab to bring everything in.

I've learned the hard way about using calculated fields in a table. I used on while building in Access 2010 for users that will be using Access 2007. Once my testers pointed out the error message, I did some research and realized my calculated field was the problem. So, I created a query to...

I was having a problem where the intellisense popup was going away as quickly as it displayed while writing code and changing my unfinished line of code to red text. In addition as I tried to type anything in the editor (commented lines included) the cursor was fighting me while entering spaces...

Figured out my intellisense issue as well! I had a timer event turned on that was firing every second. Whenever the timer fired, the VBA editor was examining the syntax of the code I was working on as if I had moved onto the next line. When i changed the timer to a larger interval, the odd...

Looks like I've managed to solve it on my own. Yay me! Instead of turning the filter off, I've changed the filter to show what I'm after. Me.Filter = "[EmailID] = " & Str(Nz(Screen.ActiveControl, 0)) Me.FilterOn = True

I've been poking at this to try and figure it out on my own and I've made a discovery. the following code works if I get rid of DoCmd.ShowAllRecords DoCmd.SearchForRecord , , acFirst, "[EmailID] = " & Str(Nz(Screen.ActiveControl, 0)) If I enter the form w/o filters turned on (click the command...

Quick addendum - I found a copy of the 3mb variant and the combobox isn't working there either. I'm starting to question if it ever worked... have I lost my marbles? I would not have moved on from a feature that wasn't working or at least made a note to return to it.

I have a form that can be opened in one of two ways. Either unfiltered by using a Command Button or filtered by selecting a Record from one of two List Boxes and then clicking the Command Button. Once the form is open in either filtered or unfiltered mode, I have a Combo Box that allows for...

Your code worked. Can presume that the & "" was superfluous? And would that make it superfluous everywhere else I'm using it? Thanks for taking the time to help me with this. I wrote my first line of VBA less than 2 weeks ago and Google has been my only teacher.

so it was the quotes for the field and table prior to my criteria that was causing the issue? I added those after I viewed the page you referred me to.

I understand your response better now. In the context of this database, email is synonymous with Trouble Ticket. I'm not actually dealing with email address here. The ResponseDate field is a date field. listAllEmails.Column(0) is a number: the EmailID from tblEmails my intent is to tell the...

OK, I now have: If IsNull(DLookup("ResponseDate", "tblBANANA", "[BANANAID] = '" & Forms!frmGUI!listAllBANANA.Column(0) & "'")) Then But, now the debugger is giving me a type mismatch

**anywhere you see the word BANANA, I really meant e-m-a-i-l. Apparently I can't post e-m-a-i-l addresses because I haven't posted 10 times** Lets disregard the fact that there isn't a single @ in this post (well, there is now!) I have a form with two list boxes on it: listAllBANANA and...

Re: Hope this is the correct place to ask I'm trying to figure out how to edit that at this very moment. It's updating the title on the individual post, but not for the thread in general.

Re: Hope this is the correct place to ask Holy smokes you guys are fast! Love the IsDate test! Fantastic suggestion! Problem solved. So much syntax to learn...

So, about 3 weeks ago, I decided to rebuild a database that my workplace uses. The original was built in '05 and has been stagnant since that time. I hadn't used Access since about 2002 and had never written code before. Needless to say, this was a big undertaking. Everything I've learned is all...