Search results

Is there a limited field size for query? I have a text field in a table that is memo type, but once queried out, some sentences are cut off? How do i resolve that? thanks. BP

Hi, Have anyone of you encountered problem with access that is running on 2003 after you have upgraded MS office basic 2007, which is only just upgrading excel and word? I do not really see how would word/excel affect access which was untouched? How would you rectify it? thanks, BP

Whats the difference between page lock and record lock? Is page lock used to lock forms? ie, if a certain user using this form, another user is not allowed to open the same form? Another question is on exclusive use. For users with exclusive priviledge, does this mean able to bypass record...

Transfer row from 1 table to another Hi, Not sure where i should post this, but this is what i'm trying to do, 0) I have a form which is based on tbl1. On the form, there is this textbox txtA. The form can be saved by clicking a button, without keying in txtA. 1) However if txtA is keyed...

I have the tab order set to go to the next textbox after using a calendar control. However after the clicking a calendar date, the focus doesnt go to the next control, it goes back to the first control on the form. I have tried setfocus to the next control in the after update event but it...

I have a tab control with about 5 pages(or tabs). I would like to restrict users from accessing 1 of the page. How can i do this?

I am making a Form/or report that shows some stats about jobs assigned and jobs attended, and manhours incurred, response time, turn around time, etc... by a couple of engineers in their daily work. For all these required stats i have an individual query for each. However, I want to make a...

I have 8 number type fields in my table which the field size set to decimal scaled to 2 decimal places. I noticed that it states the storage size for this is 12 bytes. After using this for 1 month with about 100 over entries. Then later on, i noted there a field size which is single and only...

I have a Main form(frmHistMain) and a sub form. by default, recordset type property of the main form is set to snapshot. and record locks set to all records. Hence the user cannot change anything. my concept is to have a button to unlock the form, so the recordset property is to change to...

Hello, Is there a way to tag certain textboxes on a form? I'm trying to test for certain null/empty textboxes(tagged) at the beforeupdate event of the form. If they are empty, cancel the update without undoing, then setfocus on the empty field. A sample code to reference would be great...

Lets say I have 10 textbox on a data entry form. 1 or 2 textbox are for fields which has relationship on the "many" side. I have a button for closing the form. If in the event i have already keyed in 5 or 6 textboxes(which means a new row has been created in the table and some fields already...

Auto increment textbox on the form is [Job No]. Default value of this textbox = Dmax("[Job No]","[QT Job Record]")+1 This autoincrement starts from 1, 2, 3... ... 1st Question- I would like this field to be stored as a 6 digit number, eg. if the data is 3, then it should store as XX0003, or...

I have an auto-increment textbox on a form used to generate id's for each record. the field name is [Job No] and Table is [QT Job Record]. I set the default value of this textbox on the form as = Dmax("[Job No]","[QT Job Record]")+1 for auto-incrementing. This works fine, but However as I...

On my mainswitch board, i have some buttons to access certain forms or reports. Is there anyway i can put in restriction such as on click, enter a password, if correct then allow form/report to open, else deny entry.?

How do I set the details portion of the main form to be "no edit" but still have the combo boxes in the header of the main form able to key in data to get the correct record? I'm trying to make the form & subform records just for viewing only but the records are searched by the combo box in...

Hello, How do I change the textbox background color and font color, when its enabled property is set to 'No'? Its pretty hard to see the values inside the textbox when disabled. :p BP

This run-time error 3101 is caused by the entry of an ID into a textbox which is not inside the "One" side of the table. As I have form.refresh in the afterupdate event of this textbox, immediately it pops out this error and prompts me to end or debug. How do i make it prompt a msgbox instead...

Hello, lets say i have 10 textbox in a data entry form, the user enters data into the 10 textboxes. when the user reaches the last text box, and after entry and hit enter, it automatically goes into next record, how do i prevent the form from going into the next record and stop at the last...

I have a date textbox on a form based on a query, this date is from a table where the field type is defined as date, but when i enter something else other then the date, the system warning to state the entry isnt a valid date doesnt kick in. however if the form is based on table, the warning...

Hi, I have a form where the user keys in all the fields. After keying in, there is a button to close the form. As access autosaves the values into the table, in the event the user decides to leave without saving the record. Is there a command where I can input into the event of the "leave...