Search results

I want 3 fields in a row. Employee Name, Hours, Date. I want there to be 6 rows if there is currently 6 employees. I want employee name fields to autopopulate from list of current employees names. Hours and Date field should be blank for user input. If there are only 5 current employees I want...

I want to make a form where I can easily enter in the hours of all the current employees for a specific month on one form and then submit it all together. I want it to autopopulate all the current employee names in one field, then have a hours field and date field. The user will enter in the...

I changed the data source for my dropdown box CboTechnician and now it works perfect. I'm not sure why the other data source wasn't working. Private Sub cmdFilter_Click() Dim strCriteria As String strCriteria = "1=1" If Me.cboMonth > " " Then strCriteria = strCriteria & " AND [Mth] = " &...

When it first loads it works and it shows all the technicians. I can filter with the month and year and it works. As soon as I move the technician to any name other than blank selection it not longer pulls any data.

I don't have to have the "all technicians" option for my combobox. I just want a way to be able to show all the technicians. If I can just leave the combo box blank for cboTechnician box and have it show all technicians that would be good also. Thats what I did for my reports I had a combobox...

IT doesn't do anything. I set the initial criteria in each combo box form load and then it filters but it doesnt work for cbotechnician after I try to change the combobox and hit filter button. Private Sub Form_Load() 'Sets the filter comboboxes Me.cboMonth = 3 Me.cboYear = 2020...

Here is the query that I am using for the form SELECT tblMA_workload.lPersonID, tblMA_workload.DMISID, tblMA_workload.ien1, tblMA_workload.result, tblMA_workload.Name, tblMA_workload.dtfixed, tblMA_Audit.AuditCompleted, tblMA_Audit.dtAuditDate, Month([dtfixed]) AS mth, Year([dtFixed]) AS Yr FROM...

So I did If Me.cboTechnician > "" AND Me.cboTechnician <> 31 Then 'strCriteria = strCriteria & " AND [UserID]=" Me.cboTechnician MsgBox Me.cboTechnician and I got the message box that said All Technicians when I have all technicians selected and when I hit the filter button. If I selected a...

It doesn't show any data when I do that.

its just a number 31

Rowsource SELECT [tblUser].[lUserID], [tblUser].[szUser] FROM tblUser ORDER BY [szUser]; Bound to column 1 When I change Bound Column to 2 then it starts working whenever I select "All Technicians" but doesn't work for any of the other names selected.

So I did what you said. It seems to open my form correctly. When I use the combo boxes filters for month and year it works, but When I try to use the combo box for the cboTechnicans it doesn't filter the data properly anymore. cboTechnician drop down box gets it data from a table it has a list...

So I am trying to modify this code to use for a different form to filter for 3 different combo boxes. I want to filter for month, year and name of Technician. I want a option to filter by "All technicians" I set the form so it automatically filters for current month, current year and "all...

I like the front end and vba programming but I also like quering the data and creating reports.

Nevermind I found the solution. On my form properties. for ORDER by I found the bad reference.

I have some querys that work on their own, but when I put them on a form as a datasheet, I get the Enter Parameter value dialog box always popping up. with tbl_Bravium_hours.person or tbl_bravium_hours.date They have different equations and grouping, and counting on them. I took a table with...

I will definitely have to checkout SSIS, I have only been using the sql server management studio so far. That does sound interesting to me.

Hello, I just wanted some advice on what career direction I should go. I really enjoy designing and developing access databases, using vba code to automate different processes, making my forms interactive. I've also been learning more about sql server and connecting my access forms to sql...

I haven't tried exporting access reports to excel before but when you export it can you export it with all its formatting and colors so it looks the same? If so how?

I got it working now. Private Sub Report_Open(Cancel As Integer) Dim strCriteriaMth As String Dim strCriteriaYr As String If (IsNumeric(Forms!AuditAccuracy_Reports!cboMonth) = True) Then strCriteriaMth = MonthName(Forms!AuditAccuracy_Reports!cboMonth) Else: strCriteriaMth = " " End If...