Search results

Hi guys Anyone shed any light on this as it's only just started randomly doing this, would the code need to be simplified? :banghead::banghead::banghead: Cheers for any help..

Hi guys, I want to calculate a field using VBA, I know I can add this in the Control Source =([txtApartmentCost])*0.35 to work out 35% of the Apartment Cost. However I don't want to use the Control Source that way as it's being used on another form to run totals using DSUM. Is there away...

Hi Guy's Anyone shed some light on this, I'm trying to pick up the signatuer from Outlook and I'm getting nothing.

Hi guys Since I have split my database I'm having trouble with this piece of code on my login form. If Me.txtPassword.Value = DLookup("EmpPassword", "TblEmployee", "[EmpID] =" & Me.cboEmployee.Value <> "'") Then MyEmpID = Me.cboEmployee.Value When you update the users password it...

Hi guys I have a login form with a combobox for Username and a Textbox for password, both box have 'Enter Username' & the other has 'Enter password' which when you start to type that text disappears. I've now slit the database and when the login form is loaded the 'Enter Username' in combobox...

Hi Guys I got this bit of code I've been working on and it's probably a bit silly but I need it to recognise apostrophes. There is a missing operator somewhere maybe someone could shed some light on it. The form opens fine if say the company is called Daves but not Daves's

Hi All I have a database which is slpit both frontend and backend. Multi users have the frontend on their desktop and the back end is shared on a network. The network location may change from time to time, therefore if this happends is it possible to create a form on start up that prompts the...

Hi guys I have a main form which has a button that opens another form to a specific record which is fine. However when the second form opens and i enter data into the feilds then close the form, now for some reason it stops saving the entered data??? The form is set to the same table as the...

Hi All I want a click button that will start a mail merge in Access, so far I've tinkered around with some code over the past week and when running the below code which just opens the Word doc but does nothing else. Any help would be lovely :D :banghead::banghead::banghead:

Hi Guys When I copy Access into a new PC location it always asks to be 'saved' when you first open it up which is a pain because if you don't then it opens the DB but locks all editing. Is there a way of disabling this???? Many thanks. :D

Hi Guys I'm trying to set the desktop icon using VBA which is fine, however the shotcut isn't picking up the target path. Any ideas?

Does anyone know how to allow apostrophes in a text field with this code running on the after update event? :D:D:D:banghead::banghead::banghead::banghead:

Hi Guys I've touched on this topice previouly however to no avail, but I really need some help on this. In the DB the user can click a button which opens up a word doc which is stored in a folder along with the DB. The DB is stored on a shared drive (Network) and will be used in different...

Can this been done for any network (shared drive) path file?? Hope someone can help. :D:D:D

Hi Guys I have a button that opens a small form where the user can choose the dates between, then they click a button on that from which opens a form with a chart/graph relating to TblCustomerDetails. Everything works fine but it doesn't filter or change the chart. This is the code I'm using...

Hi All I have a combobox and textbox for username and password blah blah blah when I start up Access the login form appears as usual and is .setFocus to the combobox, silly really but I want to lose the black back color and just have it transparent when the curser is flashing. I've tried all...

Hi Guys I have a listbox with shows Name, login, logout ect. I have a textbox which filters the name using the below method. Which is fine however I then need to filter (AND) the login, logout ......so kind of like a cascading filert. or could I have a command button with the same effect that...

Hi Guys I have code below that open the file dialog to select files, when I select multipal files it only enters 1 file in my list box and not the rest. Can anyone help me please. :D

Hi Guys I have this code below and works ok with a lable box, however is won't show filtered recordset. I know its something to do with Me.lblRecoredCount.Value = DCount("StaffID", "tblStaff", strFilter) but I just can't seem to get the correct end resault. Thanks for any help :D

Hi Guy's I'm really struggling with this one, My Outllook Template is saved into 'Documents folder' when Outlook is running everything is fine when I click the commoand button to open the email 'Template' on my form in Access. Now if Outlook is closed and I click the button I get an error...