Search results

Hello, I need to automatically move to the next control in my tab order on my form using VBA. What can I use to accomplish this? Note: This isn't moving between Tabs in a Tab Control this is just moving to the next control using VBA...

Hello im looping controls on my main from from my subform and I have one issue "So Far". I have a multi select listbox on my main form and the code below is saying there isn't data in my listbox because when ran it highlights it and there are several items selected so there are things there...

I have a export to Excel and I keep getting an error message. Runtime error '1004' Numberformat method of Range failed I and it takes me to a line in my code for a time field. The time in the excel workbook converts to 01/00/1900 for every record in the Excell workbook instead of the format...

Hello, I always use: DoCmd.ShowToolbar "Ribbon", acToolbarNo ' Hide ribbon AND DoCmd.ShowToolbar "Ribbon", acToolbarYes ' Show ribbon To hide on open and unhide on close which I always use but this time its not working completly and leaving this bar at the top, any ideas as to...

Hello, I can't figure out what I'm missing in this filtered search. It either says I'm missing a ) or I have an extra ) in my query expression. Its one of my 3 searches I have causing it. '*********************************FILTER SEARCH START********************************* Private Function...

Hello, I have a check box on frm_Main called chkReleaseALL and when checked I want all checkboxes on my sub form to be true if it isn't already checked which that's what I got it doing with the code below BUT what if I uncheck the checkbox (chkReleaseALL) on my main form, how do I revert/undo...

I have a multi select listbox which is a long list, so I wanted to move the selected items to the lists top, so I won't have to scroll through the list upon reopening the form.

Hello, I have a form with a few option buttons that use OpenArgs to change the dates in a report. If the date is a Friday #7 then highlight the textbox on the report. I tried using Weekday([OpenArgs])=7 under conditional formatting but it never changes the color. How should I approach this...

Hello, I have a listbox that shows employees names and I wanted to save the list as a Delimited list separated by comma in my textbox txtCrewOneDelimited . I can get it to work BUT I need to save what's in the second hidden column of the listbox and not the first column which is and employee ID...

Hello, I have two listboxes (CrewOneDelimitedEmployees) and (CrewTwoDelimitedEmployees) using the same employee list to select from. I want to be able to if I select data from (CrewOneDelimitedEmployees) then it should remove the selection from (CrewTwoDelimitedEmployees) so I can't select same...

Hello, I have a Excell sheet that I use to print either 5 days or 4 days worth of copy's using a button on sheets heading. Anyways I need the VBA on the 5th print (Button Print 5 Days) which the date would be end on a Friday to highlight cell E7 for that print then change tit back to normal. How...

Hello, I have a button that clears my "Who Logged In" table, and the button works and it requerys the form BUT when I close the form, I get an error message. Why am I getting the message? Private Sub cmdDeleteAllRecords_Click() CurrentDb.Execute "Delete * From tbl_WhoLoggedIn"...

I need help with a function to calculate what shift the “DelayStart” time is on. I made this function below but I'm not sure if it's calculating the shift correctly OR if there is a better way? Shift 1 the “DelayStart” is 4:45am – 1550pm Shift 2 the “DelayStart” is 1550pm – 1:45am Shift 3 the...

I have a continuous form that's a search form and I need to export the data/criteria it populates in the detail section. I pieced together what I thought would work but im getting an error 3075 and debug takes me to DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9...

Is it possible to limit the number of rows in a message box? I have a loop that displays data in a message box and the max rows it can accumulate from data is 74 rows which is way to long, the Yes/No button is off the screen it's so long... Is there a way to limit the number of rows of data so...

Hello, I have a function that's giving me the error 3061 and it worked fine until I needed to add a field to the query that's a date field and a criteria for that field to a date text box on the form that I'm running the function from. Errors and Degug to: Set rs =...

I have the function below on my forms Unload Event and all I want it to do is when I close the form, if there isn't a record created then just close the form. If frm.NewRecord Then MsgBox "TEST 1 CLOSE FORM" If a record was created, then it runs through qry_FindNullRecords and...

Is it possible to alternate the background color based on a text box (txtProductID) in each row in a continious form? For example, my forms detail section has a back color and an alternate back color which I still want BUT I want it based. on the text box (txtProductID). In the example image...

I have a main form with a sub form.... The main form has 3 controls (1 text box, 2 combo boxes) and when I enter data I need to run a Public function that if the controls are null then do nothing but if they have data then run SQL and update the subform. I used On Change, Before Update, After...

Hello, I need help designing this database for collecting a number count for each products lengths on a single date like shown in the image example. I need to find a way that once I select a date, shift and employee from [frm_InventoryOverview] form then [sfrm_InventoryDetails] form will...