Search results for query: *

I am totally confused on the procedure to set top margin on a report. In page setup I have chosen default printer, since the report could be printed on different printers. My code is shown below (I have omitted irrelevant code): DoCmd.OpenReport strReport, acViewPreview, , , acHidden With...

Does anyone know how I could put small fold marks on a report.

I am printing a report, and first open it in Printpreview,hidden and then specify the printer, and then open in Normal view to actually print the report. This works ok, but while this is going on, I would like the screen to display the form that initiated the printing. At the moment, the screen...

I have a table with a primary Index consisting of 2 fields, the index does not allow duplicates. The user can input data via a form, into both fields,fld1 and fld2. what is the fastest way to check if the combined fields input will cause a duplicate in the primary index ?

I have a form based on a table,with a primary index, which is the "EntryNumber" field for that form. If I enter a duplicate of an existing "EntryNumber"( ie the Index), and then close the form using the DoCmd.close statement, I expect to get an error message, but do not. At other parts of the...

I have a recordset that I display in a datasheet. One of the controls is calculated(eg "result") based on another field of the recordset(ec "City"), and when I view this calculated field in the datasheet, I may want to edit it by changing the value of the first field(ie "City") on the...

I have 2 computers, both running access 2010 and loaded from the same distribution DVD. On one compter I can build and execute a database and correctly produce output file an MDE. If I then copy the db to the other and make an MDE file it works ok on that computer, but If I copy the MDE file to...

I have a recordset with one of the fields, "nbr" containing numbers that increase in value, but are not contiguous. I want to select records based on this field, and specifying the starting value and the next 10 records. If for example I wanted to get records starting with nbr=14, the where...

I have a combo box and want to generate an event on mousedown when the mouse is over the drop down arrow. Does any one know how can I get the dimensions of the drop down arrow ?

I have a textbox and want to change the background color to green when ever it contains text.ie after a keypress. So that when a user types a char, it will immediately change to green and stay green until the user deletes all chars. I want thisctolor change to occur before the update event. I...

I have a form with several controls. One is bound to a field of the underlying table. I want to store values that I calculate programmatical into this bound control. I get the message "you cant assign a value to this object". I am hoping that someone has wanted to do the same thing and I would...

I have a database using ADO recordsets and it works perfectly in ACCESS 2010. I then Make an mde file and it also works well in ACCESS 2010. I tnen copy the mde file to another computer using ACCESS 2010 Runtime and I get errors right away. I tracked it down to the ADO statements. I then changed...

I have a form with 8 textboxes, each storing 1 char ( a "0" or a "1"). When the user enters a char, I want to overtype the existing char in any of the textboxes that has the focus. I monitor the Keydown event for the form and when I see a valid char typed I want to add a backspace to it . Can...

I am trying to align different font styles and sizes in report control and it looks like the use of textmetrics would solve the problem. I cannot see how to call textMetrics from Access VBA. Can anyone give me a clue please ?

I Have an unbound control that I fill with a sring (using Lebans "lady.mdb" as an example, because I want to show different formats in the string) in the Print Detail event of the report. It works well until I include a background graphic on the report. The control is then covered by the...

When I open the database, the main access window has the correct size, but is a user changes the size (eg maximize) and closes the database, when it is opened next time it uses the last saved size; I would like it to always open with the original size. Does anyone have a suggestion ?

I have a control on a subform that displays in datasheet view. Can anyone tell me how to programatically make this control ( and hence its column) be visible or not?. I have tried setting the "visible" property to No and it still displays

I have a DB that has a startup form and in the open event for the form, I disable the ribbon and it works well. The problem is that the ribbon does appear for a few seconds until the startup form's open event occurs. Is there a way of stopping this appearance of the Ribbon. I am using Access...

I have an MDB saved in Access 2003. When I open this in Access 2010 all seems ok and then while in Access 2010 I save as MDE file and it owrks ok. When I then open the MDE file in Access 2003, I get the meassage "This database is in an unrecognised format....may have been created with a later...

I have a textbox on a report and it contains a string =[Title] & " " & IIf(IsNull([FirstName]),"",[FirstName] & " ") & [FamilyName] & Chr(13) & Chr(10) etc I want to start a new line after [Familyname] and this worked in WinXP environemnt. I have now moved to Win7 and it will not accept the...