Search results

well the problem is it is in our new order department, were they are entering data on a particualr ID# for the first time. The drop down menu was my last resport. Thank you for your help! David92595

Hello, Basics: We have a Microsoft SQL 2008 R2 database with an Access 2007 front end. I have to find a way to incorporate Intelli Type/Auto Fill into our database. It doesn't matter if it happens on the SQL side or the Access side, as long as it works. My bosses boss is tired of typing in...

Hello, I need to find a way to log data changes that are being made in our database. From the reading I've done online I need to turn on the system stored procedure for change data capture (sys.sp_cdc_enable_db), but I only have the standard edition of SQL Server 2008 R2. Which I've found...

I need to run a query using a sql 2008 R2, with an access 2007 front end. The query needs to allow me to set parameters for a start date and an end date. Any suggestions? David92595

yes it can. ...that and I somehow changed a setting in access which protectsmy access db's from being opened by other users, and I don't know how to turn it off. I.E. the SA username I use when logging into the MSSMS...

I did think of that, but the results were pretty good. I only had to manually enter 100 records out of 13,000...I thought I'd just take the hit and get it done.

I found some vba code that replaced what was in the cell with a tracer, in my case I used "ABCDE". I was then able to import the excel sheet, and now I am currently going through and manually entering the cells that were greater than 255 by searching for "ABCDE". If you'd like the code I...

I would like to thank both of you for your suggestions on this topic. None of my cells are greater than 8000 charaters. The largest I have is approximatly 350 charaters. I found what was causing the error. When importing to SQL from excel the maximun number of charaters excel will export is...

Hello, Basics:Using access/excel 2007, SQL Server 2008 R2 I keep getting the same error from the SQL Server Import Wizard. I've been trying to import my db, and I have all of it except for the last 2 columns. I had to leave them out to get the rest of the data in... The two remaining columns...

Thanks anyways!

Hi Bob, I was wondering what the VBA code is to close the Find and Replace box after the search has completed. Thank you, David92595

Basics: I'm running windows 7 (32-bit) with Access 2007 I currently have a Form that will open based on a user entering in a TS # (ID#) and shows various record information…your basic form. My problem is that I need to open one of several sub forms within this form based on the state of the...

I'm not sure if this is the right Fourm to post in, but hopfully someone can help. Hello, I need to export a record from a form to excel. Normally I would just just create a query to pull the info from the necessary table(s), and then export that to excel, except in this case I have a...

I defiantly will do. I walked into the office today and it turns out that this project is on the back burner until another one gets finished. So I may not respond for a day or two. Thanks again, David92595

Jeanette, I have one more favor to ask of you concerning Alberts brilliant mail merge. My boss's boss (owner) loved it so much he wants to expand the mail merge to the extent that we now need to create folders within the "Word Template" Form. I've looked at Albert's modules, and really I...

Basics: I'm running Access 2007 on Windows 7 I need to find a way to place a wild card infront of a string. ex: Private Sub Command144_Click() Dim anPath As String 'folder name Dim aPath As String 'LN Number aPath = [LN] If Client_Name Like "Andrew gordan" Then anPath =...

Sorry its taken me so long to respond. Thank you so much, it's working GREAT! I only have one small problem left that my boss wants me to fix. Every time we mail merge a document we get a pop-up stating: "Opening this document will run the following SQL command:SELECT * FROM...

First of all thank you for being so responsive :-) I've intigrated the Select case as best I can. but I'm still am having problems right around the case vb___ statements. I can't get my statements to do anything. When I click the btn nothing happends. For the code: Case vbOkay DoCmd.OpenForm...

So I'm almost done with a piece of script. My boss has asked me to add a error MsgBox, and I have no idea how to do it or where to put it in the script...before, after, do I have to put it after every If statement??? explination of the script: The macro "Find_on_click_TS2" just looks at a...

First and foremost, thank you for all your hard work on this project. My boss really likes the perspective of what this can do for us :-) Sadly, I keep getting an error message when trying to open the access file: "unrecognizable database format". I double checked to make sure we are both...