Search results

Hello, I have a query (qry_EmployeesNet) with a field (ShiftDate) and I have an expression I want to use to count times the same date was used so I can us that expression in my continuous form to highlight duplicate dates. Anyways, I run the query, and the expression below displays (Error#) for...

Hello, I need to import from Excel some data BUT not all data so after I import, I need to delete what is not needed. Using the below code behind my button to import it imports all the data from the workbook. In the image I need to only collect the data above the red line I drew in the image and...

Hello, I have a database that has a front end and back end, and I distribute an .accde to each user and if I haven't before I change the "Trusted Locations" so it isn't a read only etc. and this has always worked over the years. Recently I have a new employee that needed access to the MS Access...

Hello I have the code below behind a button to get the current Fridays date. I tried it today which is Friday so it should give me todays date but it gives me next weeks Friday. What needs to be done in order to get the current Friday even if your on a Friday? Thanks! Private Sub...

Hello, I recently have gotten this error message that im out of memory when trying to send a report through Outlook. I have been using this program for a few years now and periodically have seen it and my work around was to save it to my desktop and send by attaching but that defeats the purpose...

I have a report and in the detail i have a textbox (txt1) that has a true or false value. I also have a textbox (txt2) thats value is a number. I need to have a running sum textbox (txt3) that if the value of (txt1) is true then add the (txt2) number to my running sum textbox and if its false...

I have a frm_Main with a NavigationSubform called (NavigationSubform) and the particular tab I need to open is called (NavigationButton40) and the form thats on that tab is called (frm_ProductHoldData). I have a button on another tab that I want to press and have it open the...

Hello, I have a navigation form (first time trying this) that one of my tabs has a form with a subform. When I open the navigation form and select that tab with the form/subform I get a popup that is asking for a criterion that the subform uses and is linked to its form if that makes sense...

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