Search results for query: *

I have a field called cmbFonts & I would like to populate it with the font values that are valid for the given PC. It will show up on a form as a combo box & the users can then choose the font they would like stored with the given record. Does anyone know how to do this? Thanks!

The code below lists every printer that I've ever accessed, but I really would like to list only the ones that are currently hooked up to my laptop. Is there a way to do that? For Each prtLoop In Application.Printers PrinterList.AddItem Item:=prtLoop.DeviceName Next prtLoop

I'd like to put a combo control in a form that will allow the user to select a fontweight for each record & store that weight, then use that weight in a report. I can hardcode the weights in, but is there a way to just read them from access? I'm assuming I'll be using additem, but I can't figure...

I use DSum to create a running total in a form. The form blinks 5 times before opening & this is disturbing to the user. When there are only a few records, this in not noticeable, but when there are over 1,000 records, it is. Any advice on how to correct this? Is there another way to create a...

This is my problem: I have a combo box which works fine when Caps Lock is off. Here is an example of the problem I have when it is ON: The valid values in the combo box are Pan Penn When I tried to enter PENN, with caps lock on after I typed the letter "P", the word "Pan" appears...

I have a 47 page document including a table of contents. When I try to edit it, I get this message & I can't edit it! I defragmented my disk, so that's not the problem. Any advice would be much appreciated!!!

I use a laptop & connect to different networks. I have the following code to create a list of printers: Dim prtLoop As Printer Dim varItem As Variant PrinterList.DefaultValue = "" For Each prtLoop In Application.Printers PrinterList.AddItem Item:=prtLoop.DeviceName...

I have a field called MinGauge in a table. fieldsize: single decimal places: auto In a query, I have the following code: MinGauge Test: IIf([MinGauge]>0,[MinGauge],0) When I print run the query , here's a sample of results: MinGauge Test 0.015 0.0149999996647239 0.1...

When I enter data into a datasheet manually, my notinlist code works fine, but if I try to copy & paste append from an excel spreadsheet, invalid data can be entered - my notinlist seems to be disabled under those circumstances. Any advice would be most appreciated!

When my user tries to paste incorrect data into a form,I get 2 messages. The 1st, I've been able to suppress & replace with my own message. The 2nd, "records that... was unable to paste have been inserted into a new table called paste errors". I know that it is error # 8511, but I can't figure...

I'd like to try to create an MDE file, but when I go into Tools & Database utilities, all the options are enabled EXCEPT Make MDE File. Is there something I should be doing to enable this option? Thanks!

I have a report that consists of several subreports. In the report, I total the fields of the subreports. But if one of the subreports has no data, the total gives me #ERROR I would like it to just count that field as a 0. Any ideas for how to accomplish this would be much appreciated!

My currency textboxes default to 0 appearing when entering a new record. The user then has to blank out the textbox before entering true data. Is there a way to eliminate this 0 and just show a blank text box? Or even better, have the textbox highlighted or selected upon entry, so that if there...

I have 2 txtboxes on a form : DolAmt & TotDolAmt. Dolamt is user entered, TotDolAmt = Sum(DolAmt). I would like to test that TotDolAmt has a certain value before closing the form. My problem is that TotDolAmt is not being recalculated to include the value of the record that was most recent. I...

I have a datasheet form & would like to automatically select, copy & paste append a record when the user checks a checkbox. I coded DoCmd.RunCommand acCmdCopy DoCmd.RunCommand acCmdPasteAppend in the check_afterupdate event, but it keeps appending a blank record...

have a subform within a form. If the total payments in the subform is > the DolAmt in the form, i would like to set the payment in the subform to 0. I do a recalc to ensure that the total payments showing in the main form (which - Sum(payments) in subform gets recalculated. This is all happening...

I have a form with a total in the footer (=Sum(field)) & would like to use the updated value in an event before leaving the form, but in the Unload Event of the form, the total has not yet been updated, & by the Deactivate Event of the form, it is gone.... Any advise would be much appreciated...

I am assigning a printer & issuing a command to print a 1 page report using the code below. There is a 10 second delay while I wait for the report to print. Is there a way to have the report print in batch or background mode so I can continue working while the printer/report is set up & prints...

I'd like my form to move automatically from 1 record to the next with an 8 second pause between each record. Is there a way to do this? any advice would be most appreciated!

I've had all sorts of strange things happen in Microsoft office 2002 - I get hung when I want to save a file & change the directory from the default. I've had simple commands that I know work in Access not work. I've had to retype lies of code into a new access form in order to get them to...