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

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

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

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

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

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.

A2003 on WinXP In my control events I have a standard error routine called DispError which needs the name of the event that generated the error. A typical control event looks like this: Private Sub Form_Timer() Dim procname As String On Error GoTo MyError procname = "Form_Timer"...

A2003 on Win XP I have a form with a subform. The form contains one main record, the subform contains all detail records related to the main record. The subform is displayed as continuous forms, as I need to have 2 buttons for each detail record: an edit button which takes me to a screen to...

I have a main form, let's call it ProjectEdit, with a subform called ProjectDetailEdit. When the main form ProjectEdit is shown, it shows only the detail records linked to the main record. But the detail records are not sorted. The recordsource of ProjectDetailEdit is the table, not a query, at...

I'm developing an A2003 application and making changes to forms. Whenever I save a form, it takes 5-10 seconds to save it. However, this doesn't happen with my other applications, developed on the same machine, using the same version of Access. - I have Win XP. - I have at least 1GB of ram...

Win XP with A2003 I have a form called ProjectEdit. ProjectEdit shows a single record from a table called Project, with the key field being PRID. When I click an Edit button, I want to open another form, called ProjectDetailEdit, showing only detail records related to the record on ProjectEdit...

WinXP with A2003 I would like to make a form with a subform. On the subform I show only a few fields. The detail record on the subform actually has many more fields (about 35). So I want to show an Edit button on the subform. When the user clicks the Edit button, I am taken to another version...

A2003 on Win XP Fieldname: Cost Fieldtype: currency (this may be my problem) Decimals: 3 I have a table with a field called "cost". In the table def the Decimals property says "3". I have a combo box on a form which is used as a Search box, so it is not bound to anything. But the RowSource...

I have a condition where if my main table is linked, I want to make it read-only. If it is local (in the same MDB file as the screen that is running) i want to make that table read-write. What is the VBA code to do this? I couldn't find any help in Access help.

A2003 I have a loop on a form, which imports records. During my main loop I display a text status message on the status bar showing how many records have been processed. During this import process I also do INSERT queries and perhaps some UPDATE queries for detail records attached to the main...

I have a column of cells which contain a formula, which display a value. But I need to delete the column this formula is based on, so I need to convert this column to a value first. Then I need to export it to a tab-delimited text file. How do I convert a cell with a formula, to contain (and...

I have Outlook 2010 on Win XP and I have the preview pane on for messages. The preview pane goes like this vertically: In a big font, the subject The sender's name In a small font, the sent date Addressee (To) CC (if any) I don't need the items in small font. How can I get rid of them? I...