Replies

Nope W, it’s a table. It’s a transaction database, not just reporting. I am responsible for back-end and front-end development (i.e. creating triggers, DTS packages, stored procedures, etc adding fields/tables to the server-in a test area). Essentially, I have taken over as developer for the DBA. He orginally built the db, now he just maintains the server, and it’s functionality (like that is not enough). Anyway, thanks much for the input.

jd

Is the issue actually printing the snapshot, or just getting the report printed at the time the snapshot is created? If you are wanting a print at the time the report is generated, just print the report. If you are trying to print the snapshot from an un-linked database on another machine, I’m not sure how to do that.

Hope this helps,

jd

Wendell,

Thanks. It’s nice to have some numbers to throw around when I have to justify what I’m going to do. I did, however, trash my test data and re-append from production. It appears that some of the records I was using were corrupt. As an example of a corruption, if a bit field (yes/no) on the server does not have a default value, it can be left as null-which is impossible. This will cause the same error as mentioned in my first post here. thanks much.

jd

JM,

I have to develop on the Server and on the front-end. It has 137 fields. No, it is not properly normalized, but I’m doing battle with , er I mean development for, a bunch of people that are accustomed to a Mainfram flat file, so I have to keep them as happy as possible. I knew the day would come when I would have (read “get”) to normalize to some extent. I just want to have my facts before I embark on a major project.

Give the example you were trying to exclude the employees Billy, Brian, and Jeff. You say,
select * from MyTable where Name “Billy” or “Brian” or “Jeff”

When the query gets to the first record, it sees “Brian.” Brian does not = Jeff. Brian does not = Billy. So it fits. Because if you say OR, you are saying Anything besides Brian (which includes Billy or Jeff) or anything besides Billy (which includes Brian or Jeff), or anything besides Jeff (which includes Billy or Brian).

When you say AND, you are saying, it can’t be Brian, it can’t be Jeff, it can’t be Billy. Anything besides that is OK.

Hope that helps.

Go to Tools>Start up>Display Form. You select the form you want from that list. When the database opens, it automatically fires that form.

I can’t speak for XP, but if it’s anything like 97, you go to your control panel and create a new (Add) ODBC Connection under System DSN. It will request the name of the server and the name of the database, and the password to enter the database.

Once you have created the ODBC connection, AND THIS IS IMPORTANT!, copy the Access database you want to hit the SQL back-end. On the copy, delete all of the tables that you upsized to SQL Server. Select File>Get external data>Link tables.
On the next screen, select ODBC, then the System DSN name you created, then the tables you upsized. They all come down with “dbo_” in front of them. Rename the tables, and it should work. Once again, that’s on 97. I can’t imagine that it would be TERRIBLY different, but it might.

Hope this helps.

Good catch Douglas, I don’t know what planet I was on when I did that.

Arage, try this:

Public Sub ZatHere()
Dim i As Integer
Dim strCrit As String

For i = 1 To 20
If InStr(1, “2,3,10,5”, i & “,”) > 0 Then
Select Case Len(strCrit)
Case Is > 0
strCrit = strCrit & “, or ” & i
Case Else
strCrit = i
End Select
End If
Next i

MsgBox strCrit

End Sub

Oops. I forgot, just before next i you need to put in i = i +1

If instr([fieldname],”1″) > 0 then
do something here.

the instr() function will return the character position that a given string falls in, therefore if the value is greater than 0, the string exists. If you know that you will be evaluating this for the numbers 1-10 then you could run a loop like this:

Dim i as integer
Dim strCriteria as string

i = 0

for i = 0 to 10
if instr(field,i) = true then
select case len(strCriteria)
case is = 0
strCriteria = i
case else
strCriteria = strCriteria & “or ” & i
end select
end if

next i

If, in this example, the text had the numbers 1, 3, and 5 in it, then strCriteria would =
“1 or 3 or 5”

This way you could build the query as
strQuery = “Select * from Table where CriteriaField = ” & strCriteria

Hope this helps.

jd

What if I saved the XL file out to my server as Read Only, then did an APICopyFile based on what the date modified on the server vs. the date modified on the client machine? When the client opens the XL sheet, then when they save, they would have to SAVE AS, as opposed to saving and creating a newer date modified. The problem is, I need to find out what the date modified is on the XL file. So, back to the first question, can I get the date modified from an XL ss?

Sorry. Non-Numeric.

Typically, if I have to use one of many forms, I’ll call screen.activeform, or if I have to use a specific control, I’ll use screen.activeform.activecontrol. Word or warning, it makes debugging a pain.

Or perhaps the .dirty property of the form.

I’ve seen situations wherein the actual .mdb file became corrupt and copying everything lock, stock, and barrel into a new .mdb fixed the problem. Something to consider anyway.

jeff