IT guy quit. New forms printer installed and unable to relate/find form or query that default printer is pointing to
to change to new printer. Non programmer. Clueless.
program is 10MB and database is 2.3MB
searched through forms/reports/ and queries.
too much **** to look at
My workstation has a default printer that only prints A4, but I have an Access 2007 file with reports that require A3.
When I open these reports they see the A4 'default' printer.
If I try to change to the A3 printer in the report page setup (in design or print preview mode) it doesn't change - it keeps the default 'A4' and/or Access crashes.
If I change my workstation default printer to
The A3 printer and then open the Access file & report it works Ok (it picks up the A3 printer as default).
Can I use VBA to set the default printer and page setup to A3 when the report opens?
When opening Access, the default printer changes from "Letter" to "User-Defined". The output is then unreadable. I then change it back to "Letter" and all is fine until I reopen Access with the same result.
I'm using Access 2003 with a Brothers HL1440
How can I make Access leave the printer's default setting as it is?
Hi,
I wonder if this is possible! I want to change some of those default error messages that access pops up to my own messages.
Any help will be very much appreciated.
B
Hi
i followed the link below
http://support.microsoft.com/kb/179371 and was successful to put the password on my form. my question is how do i change the default password
to my own. i have tried but failed.
Any help will highly aprreciated
I have tried to change the default database with the tools options general tab. I type in the change and it sticks as long as I do not get out of Access. However, once I do get out it goes back to the old default selection. How can I make this stick??
View 3 Replies View RelatedI have a column for default value of today's date "Date()". In the next column there is formula for no of days which calculates as
No. of days = ([Today's Date] - [Audit Date]/7*5 (/7*5 excludes sat and sunday).
My problem is that default value of date does not change as i open the table everyday. I know why. Coz i introduced the date column after 200 records already entered.
Now today's date only changes if new record is inserted.
How to get current today's date everyday automatically ? when we open the database next day !
note that I am using Today's date only for calculating number of day's formula. otherwise no function of this column.
This is my first thread so be gentle.
I curently have a query based on a payments table. In the payments table there is a field called date (when the payment was processed).
I want to be able to display, in my query, the quarter that this payment was made in. It is based on financial quarters so quarter 1 starts on April the 1st.
The default of firstweek seems to be January the 1st. Can I change it to April the 1st - if so how?
Many Thanks
Hi there
I've tried to change the default of a yes/No field so that it's either NUll or "" or Yes. This has proved unsuccessful and all the fields are still showing as No for default unless I obviously select Yes
Does anyone know if there is a way to change the Default of this field to either Yes or so that there is Null?
thanks for any help!
Hello to you all, it's my 1st post here…
How can I change the default message (as you can see in the picture) that appear every time that I try to update my record?
I want to write something like "You Have to select a different Number"
And one more question, the message only appear when I'm pressing the record selectorbutton only after the user has already filled all the form) is there a possibility that I can write a code that will check for duplicate data immediately after the user typed it?
Thanks for your help
David
Access 2010. I inherited a database that I need to copy and get it ready for next year's data. There are several places in the various tables where the default value on a field is 2013. I need to change to 2014. Any vba code or macro that I can do this without opening all the tables to change the values?
View 10 Replies View RelatedIn a text box, [OrderDate], the default value is set to Date(). Now I wanna change the date without changing the default value and the new input value would be carried over to the next record until I say otherwise. Is there any way to do that?
View 3 Replies View RelatedPreviously, using Windows Professional 2000 and Office Professional 2000, a Access File > Export... would always assume (default to) Excel (.xls) as the "Save type As...".
Now, my system has been upgraded to XP Professional and Office Prof 2003, and now the File > Export... always defaults to Access (*.mdb,...) as the file type. It is not a big problem, just a nuisance. I don't like repeatedly re-selecting *.xls from the drop down list every time I export. (After all, computers and even upgrades should make our life easier, not harder, right?)
Can I somehow select or configure Access to use *.xls as the default Export... file type?
I have a mainform with a listbox and a subform sitting in the mainform. The default view of mainform is single. The listbox displays a list of people. When the user clicks on a row of the listbox the subform shows detailed data about that person. The layout of the subform covers almost half of the area of the mainform. It works except that the subform automatically takes table view as if there were many records to display although it displays only the selected record. This automatic manipulation of the default view does not look good at all.
View 12 Replies View RelatedHow to change the default message of Exist table. the message shows like as. I wanna change this. How can i will do this?
View 1 Replies View RelatedI've got a form (frmEdit) that allows users to search tblMain for records using a bunch of unbound controls and a dynamically created SQL statement. Search results are displayed in a subform (subMain), and the current record in the subform is displayed in a set of bound controls on frmEdit.
Now the important bit: There is a set of unbound checkboxes on my form that allow the user to change which fields are visible in subMain. This is accomplished by the following:
Code:
Private Sub chkName_AfterUpdate()
If Me.chkName = 0 Then
Me.subMain.Form.CorrespondingField.ColumnHidden = True
Else
Me.subMain.Form.CorrespondingField.ColumnHidden = False
End If
End Sub
Certain fields are visible by default, but the user may want to change which fields those are. Here's what I've done so far to accomplish this:
Created a button (btnChangeDefaults) that opens a form (frmChangeDefaults)
Put checkboxes for each table field on frmChangeDefaults
Put a "Cancel" button (btnCancel)* and "Done" button (btnDone)** on frmChangeDefaults.
*btnCancel just closes frmChangeDefaults without making any changes to frmChangeDefaults or frmEdit
**btnDone changes Forms.frmEdit.Form.chkName.DefaultValue to Me.CorrespondingCheckBox.Value and then closes frmChangeDefaults
This all seems to work quite well, actually. Debugging confirms that the default values of the checkboxes on frmEdit are indeed changed when I click btnDone. But when I close frmEdit and re-open it, the default values return to what they were prior. This happens even when:
I close frmEdit using DoCmd.Close acForm, "frmEdit", acSaveYes
I close frmEdit after using DoCmd.Save acForm, "FrmEdit"
I save frmEdit manually by right-clicking and pressing save
What am I missing here?
Any way to change the default way a field is selected in a form so that it doesn't highlight all the text when you tab?I have the standard black text on a white background but when the whole field is highlighted it looks ugly and I think is quite difficult to read until you click into it.
View 3 Replies View RelatedI have a form with a subform where I want to select (via button) which format to open the form in. Opening the form is simple, DoCmd.OpenForm (FormName),acFormDS to open in datasheet, however, the subform opens in default view (single form). Can you programmatically set the property on the subform to change the Default View from Single Form to Datasheet and back?
View 3 Replies View RelatedI am using a DLookup to default a value in my TextBox. This text box has an event attached to it that updates a table when a different value is entered.
I am having difficulty in getting the default value to reappear when I change my criteria.
For instance Manufacturer is Ford
Colour is default Black
I Change the colour to red
now I change Manufacturer to Audi
I need Default colour to go back to Black
The Lookup Table says Black its just that the default value only seems to run once, first time in and never again unless i exit the database and reopen it.
I have tried adding
Form.Repaint
form.Refresh
Form.Requery
to my afterupdate query
how to change Access default error messages with custom messages? Like, if I enter some data in a sub form where the parent form is empty new record, default error message says that 'You must enter a value in the 'column name' field'.
I want to disable this default message and display my own error message. Now I know MessageBox and MsgBox fuctions to display custom messages, but how to disable the default message.
how to change default currency in Access 2013 to a "foreign currency" (i.e. to Indonesia Rupiahs) without changing control panel (Region/Language>currency) - now setup as USA ($US)?
View 3 Replies View RelatedHello, how can I change the "default" textbox properites.
When ever I place a new textbox on the form it has certain properties which I must always change.
For example I want all my textboxes to be flat not sunken and to have a solid border style. Currently the default is sunken and transparent border so I must always change it.
I know how to do it via VBA... just want to do it immediately using default.
I am assuming it's somewhere in Windows Registry?
Thanks
Hi,
we ran into quite a serious problem the other day whilst batch printing a large number of reports from Access 2000.
For some unknown reason the print job got interrupted part way through, resulting in a large number of reports not printing at all.
Our database uses an sql fragment to set the field 'isPrinted' to true upon sending reports to the printer. This is primarily to prevent records being printed more than once.
However, if, as above, the print job doesn't successfully complete the db still, as expected, marks the record as such. This provides us with a somewhat flase account of the status of the print job.
My question is this, is there a way in vb that Access can verify the success/failure of a print job?? Are there modules or code examples available that might help us interrogate the printer and perhaps abort on error?
* Standard Disclaimer:
VB Noob! Gentle brow-slapping only please!
I wish to send a report to the PDF printer driver but DO NOT wish to switch the default printer settings. Having found some helpful code on this forum that changes the default printer to the PDF driver, prints the job and then reverts the default printer back to the original printer device.
I am still using Access '97 and although in the code, the default printer does revert back to what it was originally, the Default Printer status 'tick' no longer appears under Start/Settings/Printers.... Consequently, subsequent print jobs outside of Access go to another device and not my DEFAULT printer.......???
Any ideas would be gratefully appreciated.
Oh - in case I wasnt clear - I want to do this in code NOT using the Print dialog box.... !
Hi All,
I know I am not alone on this one, as I have seen this problem posted elsewhere before.
We have installed Access 2003 on 2 workstations in a Windows Server 2003 domain, and on both these workstations, when you mouse over the print icon in the toolbar, it reports "No Printer" and indeed, we cannot print to the network printer from Access 2003, even though a printer is installed and working.
All other Office applications print to the printer OK, its just Access that doesn't seem to find the printer.
Has anyone come across a fix for this problem?
Cheers,
Alan
Hello, i develope with ACCESS2003, i used the printer object : dim xxxx as printer, it works fine but when i install my program on my client PC which doesn't have ACCESS2003 but only ACCESS RUNTIME2003 i have an error (error c++ ... run-time terminates abnormaly), this PC have ACCESS2000 and when i run my base through ACCESS2000 to debug it i have an error (undefined object) on the dim instruction. I was thinking all aplication developed with A2003 was running with run-time2003, apparently no, is something missing ?
Thanks in advance for any help.
VINCENT