Search results

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

It is required to be 11 if it can fit Does anyone know the code? Or can anyone convert to .accdb this .mdb file http://www.lebans.com/textwidth-height.htm in the zip file here please

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

Where is format property of the textbox exactlly? Where do I find it in the options? EDIT: Found it. Thank you guys very much!!!

ok. but how do i make it say in the textbox for example "First Name"? And then when you click on the textbox or start writing it dissapears and i can type normally. And also that it doesnt save the ghost text as something that is inserted in the textbox.

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

yeah, but there is no macro for cut, copy, paste, export to pdf and so on...

i have seen that. but what code should i use in the for the menu? i cant find anywhere code for cut,copy,paste, print, page setup, close, export?

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

It was a typo error that I made. Code works.

It opens the popup and asks me to insert the value of DateOut. Then when I enter it it asks again. And in the background the subform is empty.

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

thank you gentleman. you helped a lot with your service. but do you have any solution for if one of the field is left empty? for example if only from is inserted that it still shows all of the records from that date or it only end date is inserted that it shows all record to that date? EDIT: I...

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

Ok so I just solved it. Private Sub btnUnosEvidR_Click() DoCmd.OpenForm "frmEngine" Forms!frmEngine!VID = Forms!CarV!VID End Sub