Search results

Hello all, I've been looking everywhere to find a better way of finding duplicates in a table and then recording and adding another value in that record together. Let me try to explain better. example: I have a table that has 2 columns "Name", "DOB". I would like to find all duplicate "DOB"...

I'm not quite sure where to post this question so I'm trying here because it's always been a great resource. I'm starting to get into Regular Expressions programming in Access. I've built a regular expression that searches for variations of PO BOX and RR but it only ever finds the first one...

Hello all, I'm having issues with suppressing warnings. As you can see from the quoted code below i am using DoCmd.SetWarnings (0) to supress them but I'm still getting the insert into warnings popping up instead of doing them silently or suppressed. Does anyone have any idea why this would be...

Hello All, I have some Bitmaps in a table but whenever I try to open or edit them I get an OLE Server error stating that I need to reinstall it. I'm running Access 2007 on XP. I've looked on the internet but I can't find a resolution. I've tried "Regsvr32'ing" comdlg32.ocx and Triedit.dll and...

Hello all, I have a text box that has an iif statement in it and a referenct to a numerical value that is suppose to be a currency. The table that is providing the source for the report show the value as $x,xxx.xx and if a create a text box with just it in the report it shows as $x,xxx.xx...

Hello all, I know vba and I know mainframe. What I would like to know is how to connect to a DB2 table on mainframe and pull the data and put it into a access table. I don't know ODBC really but it looks like it's what I'm going to need to use. If anyone has a tut or can walk me through...

Hello all, I'm having an issue with using an ODBC connection with a pass-through query in access 2007. I have Oracle 9i installed and am on Windows 7 32 bit. This only seems to be effecting Windows 7 users and not XP users. The error in the SQL Log is this.  CLDemoFE...

Ok. This is going to be a stupid question but its really earking me that I can't figure it out right now. :banghead: I have two tables. TableA and TableB They both have the same columns. I need a query that will look at the diferences between TableA.Column1 and TableB.Column1 and copy whatever...

Ok this should be easy but I’m going a little crazy because I can’t seem to figure it out and I’ve been looking everywhere for a working answer. I have a table that has a date field set to text. I use the Mid function and get just the month in a query. I have a textbox on a form that when the...

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'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

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...

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.