Search results for query: *

Good afternoon all, Been all over the place trying to find an answer but alas, still in the dark so here I am for some help. We have an Access 2003 database that has linked tables to a SQL Server 2000 database. We have some users that use a SQL userid and password that gives them R/W access...

I've searched the web and can't find that anyone else is having this trouble. My users export query results to DB4 files regularly from Access 2003 databases. They are having trouble with either Access or Windows truncating the file name down to the first 8 letters of their file name. I have...

Good morning, Have hunted around here and a couple of other forums and am not finding a simple solution to this problem. I am writing a module that will export some report data to excel for the user. I want to check the currentproject.path directory to assure they do not have more than 220...

I am working with several subreports on a main report. I need to prompt the user for a year to use on all the subreports and I would also like to use that year in a textbox title. I have inserted the [Enter Year: ] prompt in the record source SQL for each subreport and in the control source...

Good morning! I am working on a report and I am setting the data source for the report by creating a SQL statement in the code and then assigning that string to the datasource property. My problem comes in when I attempt to call a function I created in a module. The function takes a string...

Good morning, I am working with a report that I would like to have the user preview and print but then when they use the window close button on the upper right, I would like it to simply close the preview without saving any changes and without prompting the user if they would like to save the...

Good morning, I am working on a report with several subreports and I need help on an issue I am struggling with this morning. The user has an opportunity to choose which of the subreports that they would like to include in the main report. I have successfully coded to make the...

Good afternoon! I am having a couple of problems with my SQL on this particular problem. Here is a summary of my query need: Choose all records from the CouncilMembers table that have a matching intake record. There may be multiple councilmember records for the same intake record. I want to...

Hi all, My name is Peggy and I'm new to the forum but very excited to have found you. I have a SQL challenge and I will be the first to admit SQL is not my strong suit. I need a query to do the following in Access 2000: Choose all records from the CouncilMembers table that have a matching...

Hi all, My name is Peggy and I'm new to the forum but very excited to have found you. I have a SQL challenge and I will be the first to admit SQL is not my strong suit. I need a query to do the following in Access 2000: Choose all records from the CouncilMembers table that have a matching...