Search results

There is reason for my madness... I have a table called quotes which creates an automated quote ref... When the client orders said quote it then appends certain information to a different table called projects which creates a different automated number as a project ref... However if the...

ok so how would you do such a thing and avoid the error

Hey Folks, I have a form with a sub form... I want to know if the following is possible... If I have a check box on Master Form and make it there is a tick in it, can I make a check box on the sub form do the same i.e. Master form ticked = sub form record ticked and visa versa Many Thanks

Thank you... How did I miss that!!

I created a logon form using a table of data which contains the following fields cboemployee txtpassword txtaccesslevel the idea is that the employee selects there name in the cboemployee drop down list and when this is selected it automatically adds the access level in txtaccesslevel i.e...

Folks, I have the code below but the line in red comes up when I type it. I basically want to put 3-4 peoples emails on this line so an email is sent to them people only when the form is opened from a previous forms command click. Anyone able to help?? Dim OutlookApp As Object Dim MailIt As...

thanks folks the extra & fixed it

I have an issue with the code below, i keep getting a syntax error on the red line anyone able to help?? Private Sub Command24_Click() With CodeContextObject On Error Resume Next DoCmd.RunCommand acCmdSaveRecord Beep MsgBox "Order Successfully Updated and...

I'm sorry guys, hold fire on my requests I may have to change how it's all works, I forgot about the cancelled orders and the yearly sales reports etc... I will have a rejigger and see how I'm left and come back to you guys in a couple of days

Thank you it worked a treat once I got time to sit down and work on the db.... I do now however have another request from management and wondered if it is even possible.... In broken down terms... The quote has been placed on the db and that's all fine and working, an order has been received...

Never done anything like that can you possibly give me a step by step, sorry to push my luck but this has fried my brain...

Does that go as a module or vba code against a command click

Ok here goes... I have a form which has some sales data in it... For each record (quote number unique ref) there is a folder on a hdd partition, which contains other folders and sales paperwork (costsheet.xls and quote.doc) related to this particular quote. On the form there is a text box...

Hey Folks, I am a novice when it comes to VBA/API, and need some help and am now up against my deadline for showing this database working and I cant get this last part working. I need to return a folders directory to a text box on my forms record called Files_Directory when i click the Browse...

just being a complete novice here... I have had a look and just want to confirm a couple of things. . I want to save the directory path for a specfic folder and not a document will this still work???

hey folks, could someone please provide me with a bit of code to combat the following... I have a textbox on a form, and I want this to be filled with a directory to a folder which will contain more folders and files related to this folder... I just want a simple browse and string save. Also...

Hi folks, Working on quite a large form, which has worked perfectly until recent... I looks at around 100 different querys to return a number of different DSUM amounts, which refresh every minute or so, however today I had every one giving me an error in the unbound text box. I was able to...

Can Anyone tell me what is wrong with this?? Private Sub Form_Open(Cancel As Integer) If [AccessLevel] = "Sales" Then DoCmd.OpenForm "Sales" Else If [AccessLevel] = "Manager" Then DoCmd.OpenForm "Manager" Else If [AccessLevel] = "Service" Then DoCmd.OpenForm...

Hi Folks, I have seen the answer I want before but now cant find it again. All I want to do is have some code for when a form opens: if Access Level = Sales then open Form Sales and so on could anyone please show me the code I want?? cheers Daniel

Hi folks, Not to sure if this is the right topic to post in but I'm 80% sure it is... I have a number of querys which search by month and year, I want to be able to sum up 3 of the querys together and display this in a text box on a form... I have tried dsum etc but I can't seem to do it... So...