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

Yes please show me an example. Thanks.

I had some simple code in forms that checks if all required fields are filled and then performs some arithmetric and updating some other tables based on the entries in the field in the form before update. another error i had was "unreserved error" when i tried to save/exit a form. Sometimes i...

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

Yes the number is allocated(not autonumber), using dmax+1 in the default value property of a textbox control on the form. Which on form load, I'll have the dmax+1 retrieved and there before other fields are entered. I thought the form doesnt update till it closes or goes to next record? Then...

I have a form with an autonumber control having default value of dmax+1, if 2 user entering the form, they would obtain the same autonumber, this would be a problem. Would I be able to lock the form if there is already 1 user using it? ie; without the 1st user closing the form, the 2nd user upon...

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

Thanks for the reply. because tbl2 has a primary key field which is an autoincrement number. this number must run in sequence and only be generated when there is a valid value in txtA. However there are times when txtA is blank, which means the record cannot be saved if the key is not...

Tried, that doesnt work properly. Same result as using setfocus command. Tried this command in After-update event- focus goes to the 1st control of the form and the date selected is not saved. Tried this command in the on-exit event - The focus goes to the next control as required however...

Hi, can you please explain more on the locking function? in short, how do i prevent 2 users returning the same number?

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 went ahead and used access security anyway...its working now :P but... a few questions: 1) I noticed something... Is it true that only by being a member of "admins" group will I be add/delete users/groups? 2) If i want to disable a certain user's ability to change access levels/permission...

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

After a search on access security and briefly looking at some of the other posts by the gurus here, i think i should give that a miss. too dangerous for my understanding at this moment. Now i'm thinking of using custom login forms at the start of the db. when the user logs in, his name/user...

Right now i've not set up any access security. i read somewhere i can set access levels with the in-built security functions? Could this be used for my case? And how do i refer to the name of the user group that has logged in?

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?

Yes i understood normalisation. It was applied in my database. Perhaps the way the relationship was conceived in the first place wasnt good enough. but its too late to rethink and change now, too many forms/queries/vba/macros all over the place. So i figured the conclusion would be, the answer...

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

Alright thanks all.

Will i loose data after compacting? Because I always thought this is something similar to windows defragmentation of the harddisk. I notice sometimes after defragmenting, some files gets lost or pointers to the files get messed up. I understand that access is only 2G? So i'm trying to save on...