Search results

I have an A2000 mdb file (not split) which I moved from Win XP to Windows 7 which uses A2003. Now my code gets an error when I try to call the Date function. Error is: "Compile error. Cannot find project or library". Don't I need to set a reference to a DLL somewhere? I cannot find the...

I need to run this query, and sum info so there is only a single cus_no. My current query gives me 14,000 records. I need it to be closer to 500. SELECT dbo_LINHST_SQL.cus_no, Sum(dbo_LINHST_SQL.qty_ordered) AS SumOfqty_ordered, dbo_iminvloc_sql.loc, dbo_CUSFIL_SQL.cus_name...

Thanks for your help.

I have Excel 2010 (v14.0.6023). I have a macro with VBA code tied to a hotkey. The VBA code is supposed to get the filename, and output the current spreadsheet tab to a tab-delimited text file. Well, times have changed and now I have spreadsheets with multiple tabs. How do I use VBA to get the...

A lot of my job has to do with taking a text file separated by tabs into columns, and importing it into Excel 2010. Are there any codes I can embed in my text file which will format that cell? For example, when I import my text file, in some cases I want to make the cell background yellow, like...

Holy crap. That must be it. All my forms have a clock, updated by a timer event. And the edits I was doing, that were getting hosed, were when I broke into code while running multiple forms. Is there a fix for this? I believe I have the latest patches via Windows Update.

A2003 SP3 (11.8321.8333) on Win XP I think I have some type of autocorrect turned on. Whenever I am typing in a code window my cursor jumps all over the line, so the letters I typed are out of order and is gibberish. This about doubles the amount of typing I have to do because I have to retype...

Ok I got it working. Apparently I could not do: FIle, Print, printer Properties, select Color. I had to go into Control Panel, Printers, open printer, select Preferences, then switch to color, and click OK. It's fixed now.

WinXP, Acrobat 8.0 pro, Office 2010, Symantec Antivirus and Firewall (I cannot find the version) Ricoh SP811 color laser printer Ricoh E5100 color laser printer with Fiery I have 2 PDFs, one I made on my PC and one I got from another person. Both have color in them. We have a Ricoh SP811 and...

A2003 on WinXP Hi, We order packages from many vendors and they each use one of three shipping carriers: UPS, USPS (US Postal Service) or Fedex. I have a field in my table which stores the tracking number we are given from the vendor. I have a label on my form which I want to turn into a...

I'm getting an error in this line: Set oAccessObject = CurrentProject.AllForms(strFormName) ' ERROR The error is: "This object refers to an object that is not open." I put this code in Form2_Open event, and made sure Form1 was NOT open, and got this error. Any ideas? Also, this is for A2003.

Bob, They create a new function for modularity. Every once in a while, Access stops supporting a function, property, or method, and if you have to search 57 modules to update your direct reference, it takes a lot of time. Or you could make a function, change it once, and you're done. So, I...

A2003 on WinXP I have several tables: table1 which is linked to multiple entries in table2, each record of which is linked to table3. Therefore, I have forms like: Form1 (with subform) which links to Form2 (with subform) which links to Form3. So, if the user opens Form3, I need to make sure...

I recreated the subform and it seems to have fixed things. Also, isn't the error handler labeler local to the event, since the event is actually a procedure? My example above was an exception, in that it didn't use the label "MyError:". Or are labels global to a form, report or module?

I use the same label (MyError:) in all my events on the same form, to handle errors. Is this a problem? The Access wizards generate unique labels to handle errors.

Thanks. I was hoping for an OS level utility. I don't necesarily need the numbers inside Access.

I was looking at how to do it using vanilla Access with no add-ins. But thanks.

A2003 on Win XP This is related to my form error. The form error details say I need to update to Jet SP8. I downloaded 67 Windows updates today, including some updates for A2003. Now how do I verify that I have the Jet SP8? Thank you.

I compiled my MDB file, compacted it, and restarted Access. I still get the same error. I wish Access was more specific when it gave an error message. It would be nice to point me to an event or control name that was the problem.

Thank you.