Search results

Hi Code Master, i actually went and found the answer on my own by trail and error (ie choosing random options and see what they did),hahaha, becuase i wasn't getting any replies back about teh subject, but thank you posting the answer to the question anyway. It was just a class project so i...

Hi, Is it possible to combine existing forms that I already have into one form using tabs? and if so could someone guide me as to how to go about doing it. By the way i'm using AC2007. Thanks

yea with the changes you made the autoexec of the queries does not bring up an error anymore while in MDE format but like you said it really doesn't work all that well, did a few test and sometime it would work and other time it doesn't. The search form just doesn't work at all, it still can't...

So the query isn't working? which one is it? That's weird becuase it seems to work fine on my system. The problem as i mention before is only when i made it into MDE file. The query just can't seem to find the functions inside the module. So these changes that you posted will fix the...

Sure thing, thanks for all the help bob. :D -Vincent

Okay i just went through the debug and it compile without any errors and the project ran fine when in normal format. Made it into an accde file and also into an mde file, and as soon as i run it give me that message again, can't find function within the expression. Queries don't work and the...

Hey bob, acutally i got a quick question, i posted this question in a different thread but haven't got any reply back yet but i thought since you might be checking this i might as well ask. This is about teh same project, its working fine and dandy but once i make the db file into an accde or...

Thanks Bob, I have Access 2007 and so becuase of the new security implementation the autoexec failed to run the function. Is there any way around that? Other that it work perfectly after i have to manually "enable the content" option and then run it, but then it isn't really auto executing...

Hi bob, wow thanks for the really quick reply, but i'm still a fairly newbie with access so if you could explain it a little more. I've those two queries run by a macro call autoexec so it starts at running both one after the other when i open the DB file. Now you say i should do either one...

I got these two append and delete queries in my database that i want to run on startup. I was wondering if there is a way to not have the msg that pops up to ask if you are sure you want to append/delete 0 record to table if there isn't any record that matches the condition set. I'm sure there...

So I just finished a project on Access 2007 and everything is working fine and dandy but once i saved the db project as an accde file every goes haywire. None of my queries work anymore, my search form no longer does anything, giving error msg of "Undefine function in expression". So why can't...

Hello, I've posted a few times in here already and i'm a newbie at Access but anyway i've within my table a field called 'Date Added' and everytime a new entry is created a date will be added to that field. What i want to do is everytime that access file is opened or at least somekind of...

Hey Jon, How then do i pass in that text string from that firstname field as an array into that function? Vincent

There is no Null values in the field, it is all filled. Here is an excerpt up to where the debugger pointed out the issue. I'm guessing that pWord which holds the FirstName value is not an array so when it tries to find the length of the array it coughs up that error. Though i thought that...

Also have a data type mismatch issues so i might as well post in this thread instead of creating another thread. Anyway, i did this quiery msxFirst: Function([FirstName],' ',' ') where [FirstName] is the string from the column FirstName, but when i tried to run the quiery as recieved the type...

Hi, thanks for the quick reply. I'm not quite familiar with using Access database but i read somewhere that Mysql has a built in Soundex algorithm that would do what you mentioned in the reply to my post. I was wondering if anyone can list off some of the weaknesses and strengths of both Mysql...

Hi, I'm working on a database project for class and I need do an error search type: Example: Look for the name Kathleen but with various spelling possibilities (Cathleen, Kathlene, etc). How would i go about doing this? Any help would be great. Thanks, Vincent