Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 141
Search took 0.01 seconds.
Search: Posts Made By: Tango
Forum: Forms 01-29-2013, 03:58 AM
Replies: 8
Views: 681
Posted By Tango
Re: Odd... Anyone seen this?

Oddly enough it worked under 2010 and 2007 until eventually I started getting "unrecognized database type" when trying to open it under 2007. I *noticed* the error in question roughly about that...
Forum: Forms 01-28-2013, 11:56 AM
Replies: 8
Views: 681
Posted By Tango
Re: Odd... Anyone seen this?

Could it be something odd from the Access 2007 - Access 2010 conversion?
Forum: Forms 01-28-2013, 11:05 AM
Replies: 8
Views: 681
Posted By Tango
Re: Odd... Anyone seen this?

For the record, I am still having this problem. Anyone have ideas?
Forum: General 01-25-2013, 10:48 AM
Replies: 8
Views: 6,615
Posted By Tango
Re: =environ("username")

I use the code below.

Dim suser As String
Dim sSQL As String
Dim CurUser As String

suser = Environ("username") 'Name of real person
'MsgBox "sUser = " & sUser
...
Forum: Forms 01-25-2013, 10:37 AM
Replies: 8
Views: 681
Posted By Tango
Re: Odd... Anyone seen this?

Had to edit the script to make it reflect the office 2010 folder location but otherwise it worked great. Unfortunetly it did not fix the problem though. Any other ideas?
Forum: Forms 01-25-2013, 10:09 AM
Replies: 8
Views: 681
Posted By Tango
Re: Odd... Anyone seen this?

No VBA, on this form. I will try the decompile route.
Forum: Forms 01-25-2013, 08:14 AM
Replies: 8
Views: 681
Posted By Tango
Odd... Anyone seen this?

I have a simple form based on a one-to-one query on two tables. For some odd reason it suddenly started acting "strangely" and I have not been able to nail down why.

The first field on the form...
Forum: Modules & VBA 01-17-2013, 04:32 AM
Replies: 11
Views: 1,656
Posted By Tango
Re: Run-time Error (Can't nail it down)

That matches what I am seeing from the compiler. Makes sense too.
Forum: Modules & VBA 01-16-2013, 11:18 AM
Replies: 11
Views: 1,656
Posted By Tango
Re: Run-time Error (Can't nail it down)

but when I did that it gave me a syntax error "expected=" and wouldn't compile. I think it was looking at it like I was setting a variables value.
Forum: Modules & VBA 01-16-2013, 11:16 AM
Replies: 11
Views: 1,656
Posted By Tango
Re: Run-time Error (Can't nail it down)

Just tried Call and it compiles. now to see if it works.
Forum: Modules & VBA 01-16-2013, 11:11 AM
Replies: 11
Views: 1,656
Posted By Tango
Re: Run-time Error (Can't nail it down)

It gives an "expected =" syntax error if I remove the word "Run".
Forum: Modules & VBA 01-16-2013, 10:30 AM
Replies: 11
Views: 1,656
Posted By Tango
Run-time Error (Can't nail it down)

Evening guys,
I have a user getting a runtime error on the below code (near the bottom "RUN LINKDB()" is where the debugger highlights. It works great on my computer but for some reason not on his....
Forum: Queries 12-19-2012, 03:59 AM
Replies: 1
Views: 879
Posted By Tango
Re: Form textbox (percent) as query criteria?

Ok, I solved it myself. I had to keep the data type for both fields as a "Fixed" data type. I converted it to a percentage in a 2nd query after the filter operation was complete.
Forum: Queries 12-18-2012, 11:28 AM
Replies: 1
Views: 879
Posted By Tango
Form textbox (percent) as query criteria?

I have a query that returns a percentage in one column. I have an open form with a text box that has a format set to percent and for some reason when I set the query criteria to point to the open...
Forum: Modules & VBA 11-30-2012, 11:20 AM
Replies: 9
Views: 8,397
Posted By Tango
Re: Check if ODBC linked table is "reachable"

Jackpot, I cracked it and without adding or editing tables!


curtbl = CurrentDb.TableDefs("help table").Connect

On Error GoTo con_error

Dim cnn As ADODB.Connection
Set cnn = New...
Forum: Modules & VBA 11-30-2012, 09:34 AM
Replies: 9
Views: 8,397
Posted By Tango
Re: Check if ODBC linked table is "reachable"

Both of those appear to go WAY beyond what I need to do. I don't need to re-link them or do anything to them. I just need to find out of the linked table is online. I have no preference between DAO...
Forum: Modules & VBA 11-30-2012, 09:01 AM
Replies: 9
Views: 8,397
Posted By Tango
Re: Check if ODBC linked table is "reachable"

I found that one too and frankly it confused the hell out of me.
Forum: Modules & VBA 11-30-2012, 08:52 AM
Replies: 9
Views: 8,397
Posted By Tango
Check if ODBC linked table is "reachable"

I need to check (through VBA) if a linked table is online or not. The linked table is attached to a SQL server using an ODBC connection string. If the server is offline or unreachable is what I am...
Forum: Code Repository 11-30-2012, 05:26 AM
Replies: 0
Views: 7,731
Posted By Tango
Talking ODBC Linked Table Refresh or Change VBA

I have been putting together a way to re-link ODBC linked tables through VBA in Access. At times our server name changes so this code will prompt the user to provide a new server name without...
Forum: Modules & VBA 10-23-2012, 07:08 AM
Replies: 7
Views: 3,774
Posted By Tango
Re: Sending Reports to Multiple Recipients from Access 2010 Using Outlook

The first thing that jumps out at me is that you called the file name but not the location.

sFile = "email.txt" should include the path not just the name.
Forum: Modules & VBA 10-23-2012, 03:09 AM
Replies: 7
Views: 3,774
Posted By Tango
Re: Sending Reports to Multiple Recipients from Access 2010 Using Outlook

Need to see the rest of your modified code to help you. I would check your sFile reference to make sure you identified it correctly.
Forum: General 10-19-2012, 05:44 AM
Replies: 3
Views: 615
Posted By Tango
Re: splited database

You are most welcome.
Forum: General 10-19-2012, 04:53 AM
Replies: 11
Views: 866
Posted By Tango
Re: Insert two values into a cell

NP, let us know if it works for you.
Forum: General 10-19-2012, 04:47 AM
Replies: 11
Views: 866
Posted By Tango
Re: Insert two values into a cell

Pr2's solution looks good to output the field into seperate reports. Mine will help you get both fields stored into the same field in your table.

Two sides of the coin.
Forum: General 10-19-2012, 04:43 AM
Replies: 11
Views: 866
Posted By Tango
Re: Insert two values into a cell

Sorry, I was getting hung up on the word "Print". Couple ways you can fix this but the easiest would be to use vba to set the merged fields.

Form1
-----------------
1stFieldToMerge...
Showing results 1 to 25 of 141

 
Forum Jump



All times are GMT -8. The time now is 02:30 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World