Search results

Are you referring to going to a code window, then doing Debug, Compile? Or is there another compile option?

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

Found a link: http://www.access-programmers.co.uk/forums/showpost.php?p=1063735&postcount=2 I put the code in my main form's Activate event and it works.

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

Many things about Microsoft products are intolerable. But that is a whole different thread. I reinstalled A2003 and now I see on my right click menu 2 Access items: - "Microsoft Access Database" creates a .ACCDB file, which I do not want. - "Microsoft Access Application" creates the MDB file...

Thanks, but I am unable to create a new .MDB file. My file is an Access 2000 format file, and the Access exe is version 2003. But I installed Outlook 2010, Word 2010, and Excel 2010, which wiped out my ability to create a new blank MDB file. When I right click in my File Manager, click New, I...

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

Ah, thanks. I was using Datasheet view.

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

Yes, that was it. Cost field was changed to a type of Single, and 3 decimals. It shows up correctly in the combo box now. But on the form I can change the Format to Currency, which shows the dollar sign plus 3 decimals. Which is what I want.

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

Well, this is what I got after some experimentation. ' A2003: is a table linked or a regular local table? ' May 2011 dim mydb as DAO.database dim tname as string Set mydb = CurrentDb() tname="Mytable" If (Len(mydb.TableDefs(tname).Connect) > 0) Then s = "ERROR: " & tname & " is linked...

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

I am opening an older .DOC file in Word 2010 (I recently upgraded Office). But it always opens in Print Layout mode. I want all my documents to always open in Draft view mode. I could not find any settings for this. Can someone help me? Thanks.

I disagree. HFCS is a major part of the problem. But ignorance and laziness is the other part. See my comment above about people dieting by eating grilled chicken sandwiches with extra mayo? American ignorance is boundless.