Search results for query: *

Could anyone advise the best way to extract a number portion of a specific string i.e. 1234/rejnf23 - to be 123423 00277g- 99 - to be 0027799 still need the leading 00's pp3pp3pp3 - to be 333 etc

I wonder if someone could please help with the dcount syntax for a yes/no field (Approver) i have : If DCount("[tuuser]", "tuuser", "[tuuser] = '" & Me.pword & "'" And "[Approver]" = True) > 0 Then comes back with type mismatch

I have started to develop a control system for a small company and the requirements are growing every day, the database will be used by 20 users eventually (we are now looking at sever 2003 to beat the 10 user limit). I fear that the database could grow quite large, what is large in terms of a...

Im trying to count how many records have a null entry in field [credit], ive tried : Me.var1 = DCount("[Pono]", "PO Returns", "[credit] = ''")) [credit] is a text field doesnt seem to count correctly - can anyone help please ?

i have a combo box selecting customer, then have 4 controls showing combobox.column(1) to combobox.column(4), the contents of these control change afterupdate, is there any way i can get them the controls to update if i just FLOAT over each combo data line, ie not press down-arrow.

I have the following code on a form control code If IsNull(Me.Code) Or Me.Code = "" Then Cancel = True /code works great to prevent null input, but i also have an exit command button to close the form, but if cursor on the me.Code control, exit button cannot be pressed. Any ideas please

I have the following in a normal form, coded to a button and it works fine : me.test = DMax("[Warranty No]", "Guarantee", "[Company] = '" & Me.Company & "'") + 1 i then included the same statement into a sql update command and get "Expected end of statement" error with the "[Warranty No]"...

I have a datasheet within a form where the user can enter multiple records, is the a way i can replicate the input from (record 1 - field A), when (record 2 - field A) has focus Basically the input of this field will be mostly the same once record 1 - field A has been updated.

I have a form that has various inputs, combo boxes, radio buttons etc, the form is bound to a table. I am getting a problem that every now and again the user is entering the data but as SAVE button (a macro button) is selected the record does not write to the table and there is no warning that...

Im a bit confused, I have set up windows server 2003 std and have created domain tu.local, i have also set up and linked 4 client pc's with vista business. the main requirement at the moment is to file share from the server. I know that XP and Vista home cant link to a domain. but i tried to...

I have a need to install windows 2003 server in an office of 25 users, basically just for file sharing (MS access database), does this mean i need the windows server 2003 - 5 CAL version along with a further 20 CAL license, my question is because im only using file sharing, do i have to have the...

Im new to installaing W.server 2003, so please forgive the basic level of question, but im now installing it on a pc. I need to use it as a file sharing system only. Am i correct in thinking that I : 1. install os 2. install active directory 3. create users 4. share folders i will be linking...

Im new to installaing W.server 2003, so please forgive the basic level of question, but im now installing it on a pc. I need to use it as a file sharing system only. Am i correct in thinking that I : 1. install os 2. install active directory 3. create users 4. share folders i will be linking...

I have a subform in datasheet veiw and need to remain on the input field / record if null or zero is entered, the problem ive got is that if i press enter the control moves to next field and if i press up/down arrow the control moved to same field but next/previous record and even if the mouse...

I have been asked to develop a small access database for a company that has 15 vista machines (i think they have been installed with Vista home), i need to reside the master database on a shared folder in a pier to pier setup (lets say on master1 pc - shared folder dbase). There is a limit no...

Have not posted much for a while - been busy but I have a problem where 2 users need to access an mde file, but I have had different results as to who can access it, firstly when user(1) has the file open, when user(2) tries to access the file the file doesn't open, but when user(2) opens the...

I am in the throws of developing a couple of small access solutions for 2 companies and am thoroughly enjoying the programming and learning stages (with the help of this forum aswell), but i beleive that i am not best utilising the debug facilities to assist me. Is there any tutorial / tips on...

I have 2 forms (forma, formb) and i have declared public variable as integer in forma (dtype), based upon button press in forma set dtype to 1 or 2 and open formb, then when selection made on combo box set controla to 1 or 2 (value of dtype), doesnt seem to set controla and also has affect on...

I need to filter all Flint* type door styles but I can't seem to get the Not Like working as below : If (Me.slw < 740 And Me![Door Style] not Like "Flint*") Or Me.slw > 900 Then gives expected : expression any ideas please ?

I have a control on a form and perform calculations based upon input into the control, for some reason the control has a value of 13266, and whatever I enter into the control is ignored and this number is taken as its value, I cant see any difference between this control and another control on...