Search results for query: *

Thanks for your reply. Actually we were trying to store the DSN file on the network so that everyone went to the same spot for the same DSN file. Is that not possible? I can hook up to the network copy of the DSN but it doesn't work right. Peg

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

Check out faq181 -5497 for a BuildWhere routine that loops through the controls on your form and builds the Where clause dynamically. I've used this code and it works really nicely. Peg

I have gotten that Recordset not updateable error before when my recordset is created from a query that is too "complicated" (at least Access thinks so) to update it. Hope that helps. Peggy

I am having a similar problem in that a report we have used for a long time always opened at 100% but since converting to XP last week, it now opens to "fit" instead. This is an Access 2000 file opening in XP. I really don't want to go in and do a bunch of coding if I can avoid it...

Here's the answer I found for future reference: dbBkEnd.TableDefs(strTableName).Fields("EEE").Properties.Append dbBkEnd.TableDefs(strTableName).Fields("EEE").CreateProperty("DisplayControl", dbInteger, 106) where dbBkEnd is a database variable, strTableName is a...

Moving this up to the top of the list so I can see if anyone today might have an answer for this problem. I am having the exact same issue and need the fields in the table to be set to check boxes. Thanks for any help! Peggy

Can you post the info for the shareware program? I would like to know more about it. Thanks! Peggy

Thanks for your help...had it my head I had to use DIR! Anyway, here is my code that is working. Had to change the declaration/initialization of the variable a little bit and the rest went great! Thanks again! Peggy Public Function FileCount(ByVal strPath As String) As Integer Dim...

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 double checked to make sure they are the same and they keep coming up. I just read on another forum to use a form to get the user input instead of letting Access prompt. Have done that in another place in this app so I think that is what I'll do here. Thanks for the thoughts! Peggy

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

I am using the HasData property of my subreports to determine if they are empty and if they are generating a message box to my user. Could you possibly put a label on your main report that is only visible when the HasData property for the subreport is false? Hope that helps! Peggy

Thanks Jebry! That did it! Peggy

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

That's what it was...I was sending it to design mode when I didn't need to. Thanks so much! Peggy

There is no code on the report that is actually producing the message. Is there some sort of global reports close event that I am not aware of? Peggy

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

OOOPS...never mind, I figured out what was causing it! I have a subreport with no data sitting in there. Now to go tackle that one! Peggy