Search results for query: *

I've got a table in Access with 14 fields that I'm trying to send to an Excel spreadsheet using VBA code in an Access module, and I'm getting "3265 - Item not found in collection" error. It creates the workbook fine, places the first value from the first field in the spreadsheet, then craps out...

I need to modify the following: IIF(nz([Date1],0)=0,[Date2],[Date1] to say: if Date1 is null, use Date2 but if Date2 is null use Date3 but if Date3 is null, use Date4. Is there a nested IIF(nz syntax guru out there?

We are pair-programming using Access 2000 and 2002. We have a form that has a list box that gives different results on an Access 2000 machine versus an Access 2002 machine (Access 2000 seems to filter or limit the results inconsistently, as opposed to Access 2002 giving us all of the results.)...

I've checked all my references and they all seem OK. It's just on this one machine that I get this error message. Does anyone have any idea why this might be happening?

I'm developing an equipment booking system, and my client would like to have a calendar display to show availability, i.e. for days a particular piece of equipment is already booked, colour those days on the calendar red. Has anyone here done anything like this with Calendar Control?

I just spent 3 hours on a form, and now it won't open (not even in design mode). No error message or anything. Has anyone else experienced this? Another programmer told me that happens quite often with Access 2000. (If that's true, I'll find another career .. I just lost 3 hours worth of...

Has anyone run into this problem before. Somehow, XP was installed with a FAT system on c: drive (about 214 mb) and d: is 10 gigs. Obviously, software installations always want to go to the c: drive. How can I reverse these and also have an NTFS system? Thanks in advance.

I'm working with someone else's app and when I try to open the switchboard, it gets stuck on the line: "Set con = Application.CurrentProject.Connection" with the error: "Run-time error '429': ActiveX component can't create object". I'm at loss at to which ActiveX...

Hi all: This works: subfrmFindWorkRecord.LinkChildFields = "EmployeeID" subfrmFindWorkRecord.LinkMasterFields = "EmployeeID" This doesn't: subfrmFindWorkRecord.LinkChildFields = "EmployeeID;ApprovalEffectiveDate" subfrmFindWorkRecord.LinkMasterFields =...

Hi: This is a weird problem. I have a field on the table "Street Name" which contains street name and suffix (e.g. Marsh Street). I use the LIKE predicate as follows: Me.Filter = "[Street Name] like ""*" & strInput & "*""" On the table, I...

Hello, I'm trying to read all the texts files in a folder and parse their fields into a Access table. When I added a loop with the Dir() function to process all files in the folder, it won't even open the first file (Error 53: File not found), even thought the file as indicated in displaying...

Hi all" I found a product called Visustin that, given a sub or function that you cut and paste in, will produce a flowchart of the code. It's $149US, which is a little steep for my means. Is anyone aware of cheaper (or free) software that will do this type of diagramming? Thanks in advance.