Search results

For what it's worth when I removed the word New from the declaration of the code in the original post, i,e, so they're like: Dim objShell As Shell32.Shell Dim objFolder As Shell32.Folder Dim objFolderItem As Shell32.FolderItem and added the Shell reference I was able to compile and run the...

Here's a good tip for debugging these sorts of problems.

Here are a few things that need attention: No commas after the table name or just before the WHERE There's no point in concatenating literals, e,g, & "," & " " & Strings can't extend from one line to the next so you do need to concatenate them Variables need to be concatenated into the string...

If you scroll about half way down it's not it the list like below? Note that you have to click on the check box to get it to stick. Just clicking on the name doesn't do it.

You can get that error if the folder name is misspelled. I suggest checking the spelling and existence of "C:\pictures" Edit: I determined this using early binding. When I switched in to late binding I found, as Mark did, that is doesn't work even if the folder name is correct.

If you just want to append the records from batch to farm with the date from the form then create an append query in the query designer and to add the date put in an expression that's a reference to the form textbox with the date. I suggest using the expression builder You should end up with...

If you make the query the record source of the report you can provide the form information to the query as criteria by adding form references to the criteria of the query. Alternatively you can put the criteria in the WHERE condition argument of the DoCmd.OpenReport.

I found that I could not add a new record with the Frm_Hire form. This was because the record source for this form included tables other than the tbl_Hire. I removed these table so that I could add new records and test the code that follows. In order for the code to add the payment records...

Update: Instead of looking at the report On Current event I was looking at the Form On Current event code which somehow along with all the other form module code turned up in in the report module. :) When I put the following code in the actual Report On Current event as shown below I get the...

Sorry but this may take me a while to fully understand. The simple set up I talked of in my previous post isn't true for the earlier versions of Access. In your version you need some code to get an image displayed. I haven't dealt with this code so it will take me a while to figure it out...

If TotalParts has something assigned to its control source, e.g., =Sum(...) or =SubformName!SomeTextBoxName you can get this "You can't assign a value to this object" kind of error. Also if this sort of thing is done to obtain the total then it seems unlikely that it's in the query. You may...

Usually the file path is in a hidden textbox control and the control source of the image is set equal to the textbox. If this is how you have it set up then I suggest making the textbox temporarily visible to make sure the file path is ok. Also control the compare the form's set up with the...

I went ahead and implemented what I suggested in my last post in the attached database. If you check the Save Points check box and click on the map it will prompt you for Location Id and will save that location in the Location table. I just noticed that if you click the Cancel button it goes...

I noticed that the MouseDown event of the image control (OLEUnbound11) gives you the X and Y coordinates of the position where you clicked the mouse. You could use this to add the map points to the table. You could put a check box on the form to indicate whether or not a mouse click was to add...

I figured it out. A line object has a LineSlant property. When set to true the lines slope up.

I figured it out. A line object has a LineSlant property. When set to true the lines slope up. I've put a check box on the form to set that property so you can play with it in the attached database.

I've posted a question about positive sloped lines in this thread.. If you want to be notified on responses to this then go to this thread and in the Thread Tools menu click Subscribe to this Thread.

I was trying to create a line that slopes upwards in a form for example a line that starts on the left margin 1 inch (1440 twips) down and slopes upward to a position on the top. I tried setting the properties as follows: Top = 1440 Left = 0 Width = 1440 Height = -1440 I get the error, "The...

Why do you have it set up as a Hyperlink? What do you have in the Address of the Hyperlink and what's in the Text to Display? Anyway if your Hyperlink is in a textbox, let's say for example named Project, to get the Text to Display you would use: Me.Project.Hyperlink.TextToDisplay and the...

If you just want to delete files I suggest creating a batch file to delete the files and then schedule a task to run it. The computer would have to be on for the task to run at the scheduled time but I believe it can be in sleep mode.