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
Thanks, I can do that, but I thought there must be a way using applications.forms or something like that in VB to actually pull out the internal values (for instance, for fontweight, it would loop through the fontweights & put the values "thin", "light", "normal", etc.. into a variable to create...
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...
You've all sent me in searching in the right direction - when I turn off "Correct TWo INitial CApitals", the problem doesn't occur. I'd like to keep it turned on, but if I can't figure out how to stop it from inserting, I'll have to leave it off.....
I have many different Access databases on my laptop, & the problem seems to be happening in ALL of them, for EVERY combo box that I've tried. Could this have something to do with the way Access is set up on my laptop?
PS - it's not just MY laptop - it's happening to other people, here, too. We...
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...
By the way, I split the document into 2 equal sized documents & was able to edit & create table of contents on each. But when it's all one document, it doesn't work...
I have no bookmarks.
The document is 41 pages long.
I tried pressing ctrl/end, deleting the last character & resaving.
Unfortunately, the problem persists.
Does anyone have time to look at the document?
It's a recipe book & I would gladly e-mail it over....
Allow fast saves was not checked.
I use 4 levels in my table of contents.
Re spelling & grammar errors - it's a recipe book, so I don't think that would be applicable.
Re fonts - times new roman 10, 12, 14 & 16 with various bolds & heading indicators.
I'm using windows XP professional.
I'm using...
I went to http://support.microsoft.com/kb/224029.
I was able to delete temp files, but when I tried to change my directory to where it said the spool files should be, the directory didn't exist.
I have 45.5 GB of free space on my c drive.
I'm still getting the error message in WORD.
Thanks for your time!
I checked it out. Track changes was off. In addition, when I turned on marking, I got a message saying "The document doesn't contain any comments or tracked changes".
Do you have any other suggestions?
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 got just tried it.
I keep getting the error message "The expression you entered has a function containing the wrong number of arguments".
I can't imagine why CDec isn't working. I even tried "CDec(MinGauge) & got the same error message.
So I tried replacing CDec with CSng.
No error message...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.