Search results

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 searchbox to retrieve the correct record at the header of the form. If i set enableedits to false, the user cannot use the searchbox to retrieve the record. The original intention of this form is just for viewing only. The user only require to key in the id number and hit enter, the...

ooh okay so its not possible to do this with a button. Thanks.

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...

Anyone? Thanks.

I got it to work. THanks All.

Thanks for the reply. I mean the tagging part. I dunt require all controls to be filled. Just some controls which are tagged. And also is there a way to tag them(controls, not the underlying table fields)?

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...

I didnt put it into the the form before update event as i have other buttons that adds new records and I dunt want this to fire everytime the other buttons are clicked. I put your code into the on_click event of my close button. It works but there is slight problem, regardless whether it is a...

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...

okay. thanks all.

exceeding 1000 is likely but not possible to exceed 1500. but with 4 zeroes I should have up to 9999 right? For the [Job No] default value property i set = Format(Date(),"yy") & Format([JN],"0000") where JN is the autoincrementing field. for next sequential number say 321, I obtained 90321...

thanks !

well the main problem is i'm unfamiliar with how things should work, especially the part where if i were to use a textbox to search and display records based on concantenated fields... Okay lets say i split into 2 fields, 1 is for the year no, the other is for the job no. For the year no, how...

i need to search by this job number though. because the job number is restarted every year hence different years would have same id number so the year appended in front helps differentiate which year it is from.

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...

Thanks I'll try it out.

Can you explain what it means by password enters as "*"? ANd maybe more detail on making the password form with the * password part. Thanks. If the password displays as ****** when entering it has better security since nobody can see it. Is that what you meant? my main form is just an unbound...

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.?