Recent content by barlee

yes, I know where they are located, and I have access to them. I don't have the VBA expertise to know how to frame a script to look in dozens of different folders for dozens of databases..... :( what other options might work?

Is there a way to find out what MS Access databases on my network have links to an ODBC table on my SQL Server? I want to see how many databases are calling to any given SQL table so I can make some decisions about the maintenance of the SQL table. Thanks....:banghead:

ok, this is what I finally came up with: =IIf(IsError([Appointment Date]),"No New Appointments",Nz([Appointment Date],"No New Appointments")) seems to be working.....fingers crossed...

I have a daily report of appointments that I want to print regardless if there are appointments or not. I set the control source on the [Appointment Date] field to say: IIf([Appointment Date] isNull,"No New Appointments",[Appointment Date]) This displays great in Report View, but in Print...

Ruth, can you tell me what kind of rights issue it turned out to be? I am having a similar problem. 'Everyone' has full rights to the network folder that the db is in, but only one user can open the db at a time. The second user doesn't get an error, doesn't get a dialog saying the file is...

I created delimited import specs in an Access 2003 database, and need to copy these delimited import specs to another database, but it copies as fixed, not delimited. What am I doing wrong?

I have a similar problem...I am making a table from another table and in my first table I have a field with phone numbers that are formatted like (xxx) xxx-xxxx (US) but when the new table is created, the phone number field is not formatted in that way, it comes out xxxxxxxxxx...how do I get the...

Lately when I create a query to append records to a table, the target table doesn't show up in the drop-down of tables to append to.....does anyone know why this might be occuring? I know the table exists because I created it! additional info: I thought I would try appending the data to the...

ok, so apparently Access likes to think things over before agreeing to function according to code..... my function Name "J:\Reports\CS1257Detail.txt" As "J:\Reports\CS1257Detail" & Format(Date, "mmmyyyy") & ".txt" worked just fine today......although I thought I was going to have to throw...

I have tried it like that as well.....I am not having any luck. As I said, I either get a syntax error, or I get yellow highlight over the line.....

I tried that name oldname newname but I can't get it to work. name "C:\myfile.txt" "C:\myfile_032009.txt" either gives me an error sez Expected:end of statement or gives me a bright yellow highlight over the whole light... it shouldn't matter if the path is a network drive versus a local...

I want to rename a text file after I have uploaded it to my database, adding a date variable. In other words, the file C:\myfile.txt needs to be renamed C:\myfile_mmyyy.txt . is there a way to write a quickie module that will do this, that I can add to my macro that imports the C:\myfile.txt...

I need to append data in one table to another table, but when I go to select the table to which the data is to be appended, the target table does not show in the drop down......I'm probably overlooking an obvious answer, but I can't figure out why the table that I want to add data to isn't...

Thanks HiTechCoach! That worked perfectly. I did figure that out last night about a half hour after I posted my question...good to know that I got it right. Thanks again! BTW, I really appreciate this forum, it has helped me so much over the years....

I want to sum only certain records in one text box, and a different group of records in another box, but i can't figure out how to write the equation. I want to get the sum of amount paid for records where linecolumn = "F" and in another box get the sum of amount paid for records where...