Search results

Evening folks... I am hoping someone can help with the below... I have a form which has 2 text boxes on it one is for imputing a company name and one is for putting in a purchase order number. I want to be able to do the following but not sure of the coding: If the company name text box is...

Hi Folks, I'm after a piece of code which works as described below. I have a save button on a form I have a append query ready to run. When the save button is clicked, I want the code to see if a checkbox is true or not and if its true I want the append query to run if its not then I want the...

I keep having an error occurring when I use this module and I cant work out why, I have made reference to the Microsoft scripting runtime etc can anyone help please Function CopyFolder() Dim fso As Scripting.FileSystemObject Dim sSourceDir As String, sDestinationDir As String...

I have this code in a module but it comes up with a compile error invalid outside procedure error at the bold red line...can anyone help?? Dim fso As Scripting.FileSystemObject Dim sSourceDir As String, sDestinationDir As String Setfso = New Scripting.FileSystemObject...

I have some code where by I want to move a folder from one location to another but the strings/paths are both on the form... I have sfoldersource = me.quote_files_directory_ref But it keeps throwing back an Error... Where am I going wrong??

Hi Guys, I have a piece of code but I need to modify it can anyone assist Dim FSO As Object Dim FromPath As String Dim ToPath As String FromPath = Me.Quote_File_Directory_Ref ToPath = Me.Files_Directory Im sure its the As Strings I need to change but not sure what to, but if anyone can see...

Afternoon folks, I have researched in depth how to do this but not got the results I want... The aim... I have a form which has a field called quote directory, this contains the path of the quote documents and sub folders, I also have a field called project directory. When a quote is...

Folks, I'm looking for a simple piece of code that does the following... If the checkbox on the master form is true then on a subform a checkbox is also true, and the same if it's false... Any ideas

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

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

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

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

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

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

Hi Folks, I have a little problem that I hope you can help with: I have a database which has a table for the quotes prepared, each record has a quote amount. In a query linked to that table I have the ability to get just a specific month view which shows all totals in that month. I want to...

Hi folk, I am trying to create a query which will return records which are from a specific month of the previous year... To better explain: If I have sales from 2013 and 2014 in Jan, I want a query which will show me the results from Jan in 2013 only... I'm just unsure on how to make a query...

I know this seems like a really novice question but I am slowly learning more about access as I go through. I will give you the scenario. There is 1-2 people who co ordinate the employees diary's in Outlook 2007, for all employees, I wanted to create a form within the database which is still...