Search results

These users are typically not advanced enough to export data to other sources or to create their own queries and reports. I'm not really sure what they want either :confused:. I think they envision being able to say, "Well what if I want to only look at my suppliers, and I only want the...

I'm betting this is not easily accomplished within Access proper and may require an additional software package (i.e. Crystal Reports or something). But, I've had some users ask to be able to customize reports a la another program we use, and I promised to look into it. This was mostly...

Any suggestions how to make this happen? Basically picture how Windows works in Explore. The servers are listed along the left, with + buttons beside them. The user can click the + button and the folders within that server appear beneath the server name, and some of them also have + buttons...

i don't know if this is possible. i have a database where the GUI is basically copied from an older database (different developer), and i've added additional elements. The users click buttons which open different forms until they get to the function they want to see, and they are telling me it's...

Yes, it works perfectly. i figured it was probably a syntax issue. Thanks so much for getting me back in the 21st century!

Sorry. The variable lastday is variant at the moment. I did try it as Date and String, with the same results. Thanks!

i have the following code to update 2 fields in a table with 2 dates. One is the day the report is run (today), the other is the value of the variable "lastday" (the value of which is last Friday, 1/2/2009 in U.S. notation, 2/1/2009 in European notation; i'm in the U.S. so will use U.S...

Thanks for your help. Sigh, i was afraid of that. i really don't want to modify the other table in the other database because the person who owns it is difficult to work with on stuff like that. There is a date field in the table (date orders were processed, etc), so perhaps i can create a...

i have a linked table in my database that i need to check the last date it was modified. If it was not modified today (via update tables in ITS backend database) then i need to display a warning message box warning the user that the data hasn't been updated today and allowing them to exit the...

Thanks. Unfortunately, the spreadsheet has a tab for each month (i.e. Dec08). The fields are the working days for that month, so at the start of each new month, the field names would change. The data would still be in the same cell, though. Perhaps there's a way to systematically rename...

i have an Excel spreadsheet that is manually (:eek:) updated daily from a mainframe app. Weekly, that data is joined manually (:eek:) with data from an Access database and sent out one to each supplier per week. The first manual process will have to remain manual for the time being as there's no...

As it turns out, the name of the spreadsheet is not required in the xlWrkBk.Parent.Windows(Spread2).Visible = True code. This works fine: xlWrkBk.Parent.Windows(1).Visible = True (Just updating for anyone who may search and stumble upon this one day).

i have a spreadsheet name stored in variable Spread1. This is the full path name that is opened in Access VBA earlier in the code. i have the foreshortened version of the spreadsheet name (i.e. "Test12-2008.xls") stored in variable Spread2. The following code generates a "Subscript out of...

Thank you! Works just fine.

Thanks. How do i write the value to a specific record of a table?

i have a module that runs daily, and, only on the second business day of the month, sets up a spreadsheet with a column for each working day in the month and saves that spreadsheet in the format "Template" & Month(date) & Year(Date) & ".xls" (i.e. Template1208.xls). Because the setup code...

Bumping in a feeble hope that someone may have suggestions this time. Google doesn't help me at all because "check box" brings up all kinds of info about the Libraries... Thanks!

P.S. i tend to comment out this code before deleting it to make sure it's just not needed. i'm a packrat by nature and i hate deleting things and then finding out they were vital. i also copy the code into Word and save it before finally deleting it, so i can copy/paste it back in later...

Um, in any code window, go to Debug in the menu bar and select Compile (database). It will run through and show you any errors, including orphan code. Orphan code for example if the original form had a combo box that you have changed to a list box and changed the name of. Any code associated...

i'm glad you got it to work for you. i did test the code first, so it must be something in how you have the module set up, etc, but as long as it works for you...