Search results

Thanks for the quick response! It produces monthly results and year to date 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...

Using the linked table manager, I changed the path of all linked tables. I made the changes in my most current version, this was the only change made in that copy. I do have the prior version saved off as a backup, I will try going back to that. Should I try updating the links again? Has anyone...

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

I did not know about bankers rounding, thank you for explaining! Your solution worked perfectly, thanks much.

I have attached an image of the form. The only textbox the user can edit is the "My Estimated Hours" field.

This is probably an obvious answer...where does this go? I tried Before Update and On Change events but could not get it to work. Thanks.

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

Thank you! One thing to note is the code is .column, not .columns (for any future users of this thread). I am still having one issue as I am doing this on a continuous form. ALL of the textboxes hold the value of the most recently selected item, not the one that was populated at time of...

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

Thanks all for the information above, I got my form working! I have the table I am updating, setup as the Control Source for my form. I am using a query for the Row Source on my combo boxes, to display a text description but wanted a numeric value to get stored in the table. What I didn't...

Thank you all for the feedback. The data updates correctly for me with the table as my control source, the query gave me unexpected results. I was able to correctly populate the combo box values with the row source property. But when I select something from the combo box I get an error about...

Thank you for your replies thus far, I think I am making progress. My intention is to display a text description in the combo box, but save a numeric value to the table. With my rowsource using a select statement to display the values from the query, I receive an error when i try to make a...

Ok, that makes sense then as to why all three tables from the query were being updated. I now have the correct control table, but am having trouble correctly populating the combo boxes. Can the combo boxes be populated with values from the query instead of the numeric values they are writing to...

I am still an Access beginner, but I also had a need for this. I put it into a function, which made it very easy to access when writing my queries. Good luck Public Function return_user_ID() return_user_ID = UCase(Environ("UserName")) End Function

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