Search results

I am running monthly reports, that also include year to date metrics. The numeric month and number of months to include for year to date, is all setup through vba code and a user form. When I pass the individual numeric month (ex. 1) in the function, the query works as expected. When I try to...

The database in question is a split database with about 75 users that is used for time reporting. The back end is stored on a network drive and each user has a copy of the front end file on their desktop. Everything has been going well for 3+ months. The path for the linked tables was intially...

I have a split database that is stored on a network drive. Most of the tables are updated via the front end with use of forms. I would like to have one table that is updated solely through a SharePoint List. All of my queries and reports are currently built with an existing table. I have looked...

I have a textbox on my form that is for "week of", always a Monday. There is vba to populate the appropriate Monday when the user selects something other than Monday via the date picker. This code is in the on change event. However, this is not friendly to a user entering a date in this field...

On one of my Access forms, a specific textbox rounds a value down if the user enters the decimal. The table field bound to it, is a long integer as to not accept decimal values. For example = user entered .5 rounds to 0 user entered 10.5 round to 10 I would like this to...

When exporting my report to Excel, some of my field values are blank. These columns are unbound fields (assigned through vba). How can I get them to display on the export? (They do appear correctly on the report).

I have checked the tab order and have cycle for my form set to = all records (but have also tried current record). After I update one of any of my textboxes in the details section and then click or tab into the next box, the cursor jumps back to the first record, first field. Please help, need...

I have a multiple column combo box on my form, that is correctly populating. When I make a selection, it displays the result from the first column. Bound column seems correct, as my table is being populated correctly. 1 - Can I display the values from both columns after the selection has been...

I have a continuous form that is using a select query to populate all of the bound controls. The drop downs and text boxes are displaying the values from the correct places. But, the form is not updating in the places I expected. Any information/help would be greatly appreciated! The select...

On a continuous form, I would like the user will add a new record via button click instead of popping open a blank record at all times. With AllowAdditions set to False on Form load, and turning it back on button click I can get a new record added. I am having trouble determining where to turn...