Search results

I have Access 2016 installed on my computer, all my coworkers have access 2016. I have multiple people using my database on a network folder. The Front end is split with back end on the shared drive. I have my users copy the front end to their desktop. I don't have any issues using my front end...

If you use a query vs a table in access linked to your pivot table in excel will it be faster? Will it make excel faster? The table in access has several fields I don't need in my pivot table. Eventually the access table is going to get pretty big. Im also using a timeline to filter my pivot...

I have query that uses a function and a dropdown box, cboTechnician to get different criteria. When "All Technicians" is selected from my dropdown box I want the criteria/function to show all values for a field except the value in my login textbox, cboUser that is open. I had previously set it...

I created a function it is named module 1 fCboSearch(vCboSearch As Variant) IT takes the value from a dropdown box cboTechnician on my main form. I want it to show all records if "All Data Technicians" in my query if it is selected from dropdown list if not I want it just to use filter the...

How do I get the top ten results of records from each group (person) for each month. I have a query that I am using that sums up several fields. I only want 10 records to be summed every month for every person. I am pulling the query over to excel and I was creating a pivot table that was...

I have some dropdown buttons where you can select a month and year and then it opens up a report for that month and year. In the report I want it to automatically calculate the number of workdays (weekdays) in that month that was selected. I know in excel there is the EOMonth formula you can...

I have 3 dropdown boxes that filters a list for me on a form. I want the selection of the dropdown box to be saved for the form, for when a user navigates off the form and comes back again to the same form. When the User navigates to a form again, I want there previous selections in the dropdown...

I have a form where you click a button then it opens a windows filepicker dialog box. I want the dialog box to show Excel files and CSV files in the filepicker. Right now only the excel files are showing up in the dialog box. I even tried converting the CSV file to excel file and they still...

I have a front end and backend database with userid and logins. I have the backend tables saved on the network shared drive. I have a front end version that will connect to the backend. The pathway to the shared folders is different for different users. When I link the backend files to front...

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

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 have a form with a few combo boxes, that will open up different reports and filter the report by month and year. I set the criteria in my queries for the reports to equal the value in the comboboxes. I I have a 3 combos boxes. One combo box is for the type of report, then one combo box is...

I have 2 tables (Q1_Workload and Q1_audit) that are related one to one by lpersonID_Q1 field. Q1_workload table has more records in it. Audit table doesnt have all matching records. I made a Left Join query with the 2 tables, called it pending_auditlist. pending_auditlist query shows all the...

I'm trying to set 2 different filters at the same time but when I try to do both it doesn't work. I have 2 combo boxs, one with month, one for Year. I want to be able to select month and year and filter my year and month fields. for my continuous form. It works when I only have the code for one...

I created some forms and reports that will use 5 related tables. When I designed all the forms I made some dummy tables within access so I could make sure everything worked. Most of the forms are bound forms. I have 2 unbound forms. I also made different querys that some of the forms and reports...

I have a pending list (form) , Completed List (Form ), both of them are using querys to pull the same data from two tables. Each list is filtered for different records, depending on if audit was completed for that record. I am using a browse to macro to navigate to MA_Audit_dataentry form(This...

I have a main form that will open up with several bound fields (patient Id, dateUpdated), from a table. Then there are 2 subforms on this main form that will be unbound and will be used for data entry that is related to the bound fields. The data entered in the unbound fields will go into 2...

I'm trying to lock down my database so when admin user is logged in, only admin user has access to short cut menus. "Allowshortcutmenus" is this setting for right click shortcut menus? Im also trying to disable the special access keys for non admin accounts. I can't get it to work. I saw some...