Search results

Hello, I am having problems opening up a windows shell to a file path in a Module Function. I have it working as a sub, but am trying to convert to a module so it can be centrally located. I can get a basic explorer window to open RetVal = Shell("explorer.exe ") However, when I try to put in...

Hello, Basics: I'm running a SQL server 2008 R2 back end with an Access 2007 Front end. I need to find a way to attach documents via my access front end. I've done some research and there seems to be quite the debate about how this should be done. I don't have a full understanding about the...

Hello, I'm in the (not) fun process of having to change the data type of our PK to accommodate new requirements set by our clients. So far the switch has been surprisingly painless, except for my current problem. Basics: Running Access 2007 Front end, SQL 2008 R2 Backend. I have an unbound...

Hello, Basics: I'm running SQL Server 2008 R2 back end with access 2007 front end. I have a Full Text Index set up on our main table which is have set up to re-index every morning at 3am, or at least that's what I'm reading in the Properties of the table. However, day after day our...

I am trying to get column history to work in my database. I've read more posts than I care to count online with little to no luck. I know the CODE is: =ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0)) But after I change our comments field to memo (already was) and change to...

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

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

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

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

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

I need to find a way to create a one click button that will select the current record from an access 2007 form and mail merge it with a predefined word 2007 document. From looking around online, I can tell you that I cannot use bookmarks or anything of that sort. It has to be mail merge-able...

I need to find a way to create a one click button that will select the current record from an access 2007 form and mail merge it with a predefined word 2007 document. From looking around online, I can tell you that I cannot use bookmarks or anything of that sort. It has to be mail merge-able...