Search results

Thanks for coming through JHB, I spent hours trying to figure out how to do a loop, but just aren't smart enough to work it out.

That's the problem, I am not sure how to do the loop. I can use basic excel loops, like if cell.value = 1 etc... but not complex loops.

That's exactly how we worked out that it was the right click script causing the problems, I thought that someone may be able to help with the code, as when you manually close forms then someone else can log into the same front end with no problems and then both users can use any forms they want...

I thought that maybe some kind of vba loop through the textboxes, so it would loop adding/ appending the records to the table if they were below the specified textbox values for each bat then shelf then place. Not sure exactly how to explain it. But if they were to put 18 1 1 2 it would out...

Multiple users are using the same front end, I have no control over them doing this as it is how my boss wants it to be. This is the only script where I have problems with multiple users using the same front end. I run all sorts of above scripts like modifying the ribbon etc... and they all...

I have the following script which customizes the right click menu and I love it. The problem that I am having is that I call the script to add the right click from the form open event and then multiple users can not access the same database. I use one for forms and then another for reports...

Hi JHB, I checked out the 2 links, but they are quite a bit beyond my ability, I don't even know where to begin with them.

I have a userform that has 4 textboxes and a command button. The user types in box1 a Rack, in box2 a shelf, in box3 a place and in box4 a shelf. The user types in Rack textbox 18 The user types in Bay textbox 4 The user types in Shelf textbox 2 The user types in Place textbox 3 I then...

I have numerous forms where I set the form properties to moveable and I can then move it around the screen, however I have just tried to move a specific form and no matter what I try I can not get it to move. The form has a caption and is set to moveable, the form has a sizable border, the...

Thanks for your help

I have used the following script to export a subform to excel but it isn't working for a report. The report name is spelled correctly etc... but the error message keeps saying error 2465 or if I enable the error handler it says application defined or object defined error. I don't want to have...

Thanks for your help, someone on an excel forum provided a script that does the job nicely, I did try transpose but it didn't do what I wanted.

Thanks Paul, sorry I was supposed to post this in the excel forum.

Please refer to attached JPG. I am trying to change the data in my rows to columns I have data as per the attached picture in columns B-I I would like the rows to be pasted to columns as per columns M-Q so row 1 ends up as the first lost of data in M-Q and row 2 ends up as the second lot of...

Thanks Galaxiom, much appreciated

I made a copy of my database named Stores and named it as Purchasing. I did this as they are basically identical except Purchasing has some other tables, forms, etc... When I click on the Debug/ Compile it says Compile Stores, is there a way to change this so it says Compile Purchasing...

I got around this by using the following script for the full hyperlink then I use another field to then do one thing for value 1 and another for value 0 Expr5: IIf(IsNull([Expr1]),0,1) Thanks again

Hi again, I have tried to use the following and it works well if there is a value in the field, however not if it is empty my field contains the following but I get an error if there is no value Expr5: Left([PDF],InStr([PDF],"#")-1)tried Expr5...

Thanks CJ London, that script works well, the part that was getting the hyperlink was from a field.

I have a query which is a concatenated field of text and then a field from a table that has a hyperlink. i.e 15mm predesigned mould Drw: [L:\10527-123-A.pdf#L:\10527-123-A.pdf#] I want it to display in the query field as just the hyperlink 15mm predesigned mould Drw: [L:\10527-123-A.pdf]