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

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

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

So i have a form where for every new entry of shipments you need to add a IDnumber to the shipment. The IDnumber is made of year and 4 digit increasing number. Here is the example: 15-0025 (the number 15 is the current year 2015, and the 0025 is the number that increases everytime, it starts...

I have a report where there are textboxes that in some cases can contain text that is longer then their width. What I want to find out is how can I using VBA make text change its font size to smaller to fit the text. I have looked at lebans TextHeightWidthVer45 but i couldnt open it because it...

I have a table with usernames, passwords and security levels in form of number 1,2,3... What I want is when you open a database using a login form where you enter you username and password,and you login that based on your security level you are allowed, when clicking on certain buttons to open...

When I open form, it always highlights the first field, or if textbox is empty it selects that textbox as if i was to write in it. there are many textboxs in the forms. is there any way to deselect the textboxes so that when i open the form this doesnt happen. if i want to start typing i would...

I would like to put an example text in some textboxes so that when people type in them they now what or in what form to type. I have seen this in forms online, kind of a ghost (shadowy) text is displayed when the textbox is empty, and when you click or start typing in the textbox it dissapears...

I am working on securing my database (Office 2013) and would like to make a custom right click menu in the whole database (not just for a single report or a form, but for all of them). I have seen that in Options -> Current Database there is an option Shortcut Menu Bar that is a dropdown menu...

I have a lot of textboxes that on a double click open other forms and I would like to make the mouse pointer into a hand (as if it were a link) when i place it on the textbox, like on hover. I have tried the function to make it as a hyperlink but since i have a double click function it takes me...

I made a subform based of a query that I put in a main form. The subform contains a date field, where a full date is inserted (example 24.12.2015.). What I am doing is making a form where the subform would be filtered by a combobox by months. This may be wrong (correct me if it is), but for...

I made a report that show a list of data where there is a date. It sorts the report by year then by month. I collects the information about the date from a field in a table where the whole date is inserted (example28.12.2014. (date/month/year)). What I want is to make a combobox or a listbox...

So I have a search form that I created that has also a subform (a continous form, that has a query as its source) where my records are listed. I started on making a Between dates filter where i would be able to pick dates and get the results of records that are in that range. I put two text...

I was wondering if there is a code for Next and Previous record in a form but for a specific value. Example: I have a customer that has a specific ID and that customer has a list of orders that all contain that ID. When I open a form for orders I would like to be able by using Next and Previous...

I have two forms. Main form called "frmCarV" and another form "frmEngine" The form frmCarV contains the its ID called VID that is connected with the frmEngine also. I made a button on frmCarV form that when click opens form frmEngine as a new entry (because the form is for entering certain data)...