Search results

Hi there, I recently started getting this in Access 03 for no apparent reason. After extensive debugging, troubleshooting and the likes, I've come to the conclusion that it's one of those Access gremlins. Based on when/where I've seen this, it's usually a corrupted database or a table that...

Does anyone know if there's a true/false property that can be returned if a table is linked? For example, I have a loop going through my AllTables and want it to do 'something' if the table is a linked one. I just need to know who to determine whether it's linked or not. Can't seem to locate...

Thanks DJkarl, but it didn't work. Any other ideas? I'm really confused cause I don't have this problem in any of my other dbs!

:eek: Hey all, I've been using this SetProperties code successfully in databases for some time now. I added it to another database but all of a sudden I'm getting "property not found" error on the line 'dbs.properties(strPropName)=varPropValue There is a trap in there (see full function...

Try this Try adding the word "New" like this (works on occasion for me when I can't figure out a run-time error): Dim OLookApp as New Outlook.Application Dim OLookMail as MailItem Set OLookMail = OLookApp.CreateItem(olMailItem)

Try this Hey there, Try this: Function ExcludeApQu(MyStr As String) As String 'ExcludeApQu removes apostrophes (') and quotes (") from a string ExcludeApQu = Replace(MyStr, Chr(34), "") ExcludeApQu = Replace(ExcludeApQu, Chr(39), "") End Function I use it in a form my customer use...

Hello everyone! Does anyone have any code snippets that will pull up the outlook address book from an access form and insert the selected contact(s) into the "To" text box I have on my form? Any help appreciated!!! :D

Thanks WayneRyan! To answer your question, I have 2 dbs that need to update each other on each coast of the US (two different network drives). I have been at this for several days writing vba sql statements, update queries and several other tried and true methods to update my tables in Tacoma...

Hello all, Need some help. I have TABLE A that contains a set of records with the TICKET # as the primary key. I have an identical table - TABLE B - in another DB in which I need to update each ticket with new values from each record with the same TICKET number in TABLE A. I am unable to use...

Does anyone know how to open an application through VBA? I want to kick off an install.exe file. I know it's quite simple, but can't put my finger on it. Any help is appreciated.

Thanks a ton - I knew it was simple, but it's one of those brain-train wrecks where you're so close to a project that the simple things elude you.... Thank you very much!

This is a really stupid question but I gotta ask. Does anyone know some VBA that will count records in a combo box on a subform? I need to do this because some of my requestors in the DB are responsible for more than one department. Their names auto fill, but I need to remind them to select a...

There's a bunch of other code after it but basically when my form button is clicked, I just have a line that says: GetFileNames That's where it breaks - right there - with the "Argument Not Optional". Seems the way the function is written, VBA thinks there is supposed to be an argument, but I...

Hi folks, I have a procedure written as shown below. When I try to call it from a button click event on a form, I get "Argument Not Optional". What needs adjusted in the procedure to fix that? Any help appreciated. Urgent issue! THANKS!!! :D :eek: Public Sub GetFileNames(FolderSpec As...

I need one of my access apps to count the number of files stored in a specific folder/directory and compare that number to another. Does anyone know any code that will count the number of files in a directory/folder? Any/all help would be greatly appreciated. This is a VERY urgent issue...

Yes I did. Still getting the message - seems access doesn't like changing a subform's properties.... Any other ideas?

At this part I'm getting "You can't assign a value to this object": If bFilter Then Me.frmPayCalculationsSubForm.Form.OrderBy = "" Me.frmPayCalculationsSubForm.Form.Filter = strFilter Me.frmPayCalculationsSubForm.Form.FilterOn = True Else...

AWESOME! Thanks Vbark! I was getting there with the filter variable but was having trouble putting it all together to make it work. I am in training the rest of this week and Mon 1/29, but as soon as I get it all worked out, I'll let you know. Thanks again!!! ;)

Hello all, I have a form that has three combo boxes. My users will select a value from the drop down that will filter a SUBform on the after update event of the combo. I'm really struggling with how to write code to do this. I currently have a hidden text box that will contain the SQL filter...

Hi all, I don't know why my app gets zero errors, but to handle them, I need to resume the procedure in which the error occurred when the error message equals "0". It's not happening. When some of my users double-click the list box to run the selected query, it nothing happens. I was able...