Search results

I am hoping that you know how to create a custom right click menu that will be in every form and report. I need it because I dont want users to be able to enter design view, and in current database setting i saw that there is a drop menu for right click menu options but is empty. I need basic...

I upgraded to Office 2016 and noticed that reports are really slow when opening. It takes about 5-6 seconds to open a report when clicked, and sometimes if you have multiple pop-ups it goes behind all of them. Has anyone else experienced this? Any solutions?

I want using If and IsNull to make user insert data in 5 textboxes before he can access rest of the data. I used this code, but when every just one of the fields is filled it open the rest of data. How to write the If and IsNull function so that it requires all of this textoboxes filled first...

I have a textbox where people insert numbers and what i want is that when they type the number in the textbox at the end it gets a measurement. Example: I type 567, after being typed it should show 567 kilos And when I change the number it would also keep the kilos at the end. But when i dont...

I have this code that would filter a subform. My problem is in the bottom of the code where using the WHERE function I filter the record source, but my problem is that it doesnt inser the value of strWhere, but it only leaves the strWhere as a text in the WHERE function and with that not doing...

I alredy looked at all of that but it didnt help me When I put all the textboxes and comboboxes to use code AfterUpdate and add .Value to end of them in the code it work. but i have to press enter after i type. and that is not what i want. Is there any way to do it with Change function??

I made the code to filter a subform from a main form. In the main form i have multiple textboxes and comboboxes that filter the subform. In the code they are connected, so they filter already filtered subform if i have used one or more of textbox or comboboxes already. It works alright when I...

Solved Fname = Dir(OldPath & "*.*") Do While Fname <> "" Name OldPath & Fname As NewPath & Fname Fname = Dir Loop Set FSO = CreateObject("Scripting.FileSystemObject") FSO.CopyFolder OldPath, NewPath, True Set FSO = Nothing

I google all of that but it isnt what I need. It needs to check automatically for all files and subfolders, grab their name and then move them. On all of the code I could find its the person that is typing the subfolder names and that is not what I want. If I have a subfolder I want the code to...

So what I want is to move (or copy then kill the files on the old location) all of the all of files and subfolders (if there are any) from one folder to another. I have made it to move files but not subfolders. Does anyone have solution for making it move/copy subfolders? Dim OldPath As...

No the new changed files and folder names dont exist. They are not created, I just renamed the string in the code with this and then I want to apply this to old folders and files to rename them not to create new folder. Just to rename old folders and files to the new names that were created with...

Thank you sir

What I want is to rename folder and file that already exist. The txturlpic1 contains the filename and extension. Example i have the old link X:\BASE DATAS\Yamaha\GTC 2.1 - John Mark\GTC 2.1 - John Mark.jpg And if i changed some data in the textboxes it should be X:\BASE DATAS\Yamaha\GTC 2.14 -...

I would be very grateful for that

If the change txturlpic it is then for adding a new picture completly. I have another code that works with that.

It doesnt actually say much to be honest. I googled how to rename folders and files. Found mostly how to rename files, but not folders as much (some said it worked for them) and Name was used for renaming files mostly. Is there any other way maybe to do this?

The line: Name OldLink1 As GetFullPic1 returns the error. I checked with ?OldLink1 and ?GetFullPic1. The links are correct but it doesnt want to rename. I think that Name function might not be able to rename folders. Maybe I am mistaken. Any ideas?

Okay so I made it work. Here is it for you if you maybe need it. With Left and Right I grabbed the parts from the last shipment number. On Right I made the last 4 digits an integer so it could grow. rest is just checking for differences in years and etc. Hope this helps someone. Dim...

I have a form where users add pictures using folder creating and placing pictures in those folders. Folder and file names are based of textboxes in the form. For editing I made a form where they can change data in those textboxes and update the folder and file names. I wrote code for this but...

Thanks, i think i will do it manually.