Search results

Sub SaveFile(Source As String, Target As String) Dim fs As Object Set fs = CreateObject("Scripting.FileSystemObject") fs.CopyFile Source, Target Set fs = Nothing End Sub

I have a table in SQL which is full of hyperlinks to pictures. What i want to do is from within a access form, look up the picture on hyperlink address, then save the picture to a local drive, The URL is transferred to the MyPic String with no issues, but i am struggling to save this as a Jpg...

19 columns in total

Still getting conversion failed when changed to a Date field. insert into...

i have changed to DateTime datatype, and tried the above, Here is my code Should this work ? insert into...

I am migrating a Access database over to SQL, The dates in access were stored as Strings, whereas the SQL table they are moving into are the Datetime Format. When i try the insert Function i get the error message below What is the easiest way to change the format, Msg 241, Level 16, State...

Thanks for the advise, initially i have gone with Issac's suggestion which seems to be working. I will look at Pat's suggestion for in the future.

Hi all, My Main Menu only shows buttons which are relevant dependent on the user permissions, this often leads with when people see the form there are blanks where the buttons are hidden. Is there a way to arrange the buttons, so the only ones that are visible are all aligned at the top of the...

thanks for the above but still struggling to pass the detail from the query to the code. my query is called "Qry_GetPics", and this only contains 1 field "Cat_No"then i want to run the code below to copy the picture from one location to the next. On Error GoTo Handler Dim PicPath As String Dim...

I have attached a cut down version of my Database. What i am trying to achieve is that on the Form FrmQcNonConformanceDeail we have a field TBSubCat. I am trying to look at this field, and then pull the email address's from the Query QryNCEmails. against that TbSubcat field and that Job...

Yes - it is a Yes / No Field. The issue was the Quotes... Thanks

Guys i am struggling with my Check box to select all records in subform. The code i have is below, The Field names Delivery is a short text field, but i get error message 3464 - data type Mismatch in Criteria Expression. if I run it as query it works, just not when i run as VB my...

Thanks, I will have no issues with the query, just not sure how to loop through the records in the query. Any tips ?

I have some code below that is called on Current Event of page, So when i refresh the page, the code automatically looks at the CatNo. and pulls back the picture from the network Drive, to a local drive, and it it cannot find the network drive - it justs gives me a No Picture.jpg. I would like...

thanks, can you help in where to call this statement in the above code ?

My code creates a email and attaches some images to the email. The images are stored in File_Location folder. The hyperlink to the images are stored in the TblQcFiles table. Some of the images have been archived into sharepoint, so are no longer in the folder, but the hyperlink is still in...

Thanks for this. I did create a new database and got thr same result when trying to open the lock file. So this is reassuring that it is not just me. I have created the batch file that checks for the lock file, and I am currently running this every hour. I have never created a batch file to...

thanks, just tried again, Opened Notepad - Font is set to Arial, then navigated to the file and opened it, it is exactly the same. I used to be able to see PC details, but this has been like this for the last few months.

Update on this. I tried opening the lock file as a txt document and got the enclosed...

Here's my setup. I have a Front and Back End, with upto 30 users at once who copy the front end to a local drive using a bat file. When Users log into front end the database should logs this user so i can see who is in the database. I have just checked file explorer and can see the lock file...