Search results

Hello, I don't know if this is possiable but I'm trying to figure out and I can't seem to find the correct words to google with. I'm putting in a date and I need to have the small "st" beside the number 1. I'm not sure how to do this or if there is a chr() call for it. Any help would be...

I actually figured it out. I just created another column with the variable I needed in it and then used it as the criteria at equal to or les then, but thank you for your time. It was an easy solution but i could not see it at the time and was over thinking it.

I've been looking all over the place and can seem to find the answer to my question so I thought I would ask here. I have a query that is based off of a two tables. I want to only display a certain number of results from the query which in one of the tables. I know how to do the top ten and...

I'm trying to figure out how to control a mainframe session with access 2007 vba. Does anyone have any ideas or perhaps a tut document that I can reference? Thank you

Do you have an example of this that you could point me too?

It does not have to be opened by using a hyperlink, that's just the way I have it for now. The article was good but its talking about changin the VBA and XML of the document. I wanted to change it in the VBA call from access to the document. Any other ideas?

Hello all, I have an intresting one. I have a form where a user click's on a document title and it opens the document in word using Application.FollowHyperlink strLink, , True I'm tring to figure out a way of opening the document so that the save options are disabled. Any ideas? Thank you.

Hello, I'm trying to run an UPDATE SQL query and keep getting syntax error's. Would someone be able to tell me what I am doing wrong. I'm getting "error#3144 ; syntax error in UPDATE statement" when I'm trying to run it. Can anybody see where the error is? I've been trying for about a day...

Ok. It's been figured out. Function getFileName(MyFileName As String) ' --- Pulls the File name and extension from a full path Dim fso As Object Set fso = CreateObject("Scripting.FileSystemObject") If fso.FileExists(MyFileName) Then getFileName = fso.GetBaseName(MyFileName)...

It's still giving me the whole path plus the file name.

I'm tying to get just the file name that get's selected in a dialogue box. I can get the path and the path and the file name but not just the file name. Here what I have so far: 'Set up the File Dialog. Set fDialog = Application.FileDialog(msoFileDialogFilePicker) With fDialog...

Hello, My database opens with an autoexec. It has no issue opening when it is an accdb and no issue opening after the initial conversion to an accde but when I try to just open the accde by double clicking it I receive the 2950 error stating that "The expression you entered has a function name...

Hello, I'm using A2007 and I have a combo box thats record source is a query. It populates fine but when I select something in the list it always goes back to the first item in the list. How do I get it to stay on the item that I've selected? Thank you.

Hello, I don't even know if this is possiable or not but I was wondering if there was a way to have Access 2007 find and replace something in a word document? Thank you.

Hello, I'm trying to create a module that when a form opens it will look at the module and set the forms title as per what it says in the module. I've been looking arround but can't seem to find a specific way of doing it. Does anyone know how this would be done? Thank you.

Hello, I was trying to figure out hoe to have a global module run and check the form that is open to see if a box existsed or not. I know how to do it for finding a table or query but not for something on a form itself. Does anyone know how this would work for the VBA coding? Thank's.

Hello, I'm trying to figure out how to click a button in a main form from one of it's subforms. I know how to do it the opisite way going form a main from to a subform but not from a subform to a main form. Any ideas?

Thank you. For some reason I thought I had tryed that but I guess not because it's working correctly now.

Hello, I have a TreeView in a, Access 2007, form and I need to figure out a way of locking it down so that the nodes that get listed cannot be edited. I've tried disabling it but then the on node click event will not work because it can't select anything. If you click on a node and then long...

That worked. Thank's.