Search results

I used a free product called "Dia" once. Works pretty good...very Visio like without the high price tag and some of the features.

If you don't want to fiddle around with maintaining DSNs, you could go with a DSN-less ODBC connection. Banana on these forums wrote a nice little (or big) article on the why's and how's. Just search here for DSN-less and you can go into the advanced search and only search for posts by Banana...

Just saw it. For those who might find this in the future, localhost is the computer you are sitting in front of. It's IP address is ALWAYS 127.0.0.1. The way Adam's cheat works is by re-routing traffic from any of the sites that he has in his list (in the hosts file) to the local computer...

No need to have a separate combo box for each interest rating: just create a sub-form for the table that holds your interest rating for the student/subject. As you enter the interest rating for the student, a new row will be entered into this table. I am quite concerned that you might have a...

Post #10 reported as spam.

Too many quote marks. The "AND" (without quote marks) is part of the SQL query. Thus, when you build it, you cannot have "" around it. WhereCondition:="Social LIKE '*" & Me.Last_4 & "' And LastName = '" & Me.LastName & "'" Or something like that.

Put the "AND" keyword between the conditions.

Depending on your backend, "char" type columns are padded. If you don't want padded fields, change your data type to something that doesn't pad, like varchar, varchar2, text, or whatever your backend uses.

Not really without seeing everything that creates the data for the report. I've been taking a shot in the dark so far on everything.

Please consider the meaning of the word "obvious". It is not obvious to us. How do you know it doesn't work? Do you get an error? What is it? Does it display the wrong data? What? No data? What do you expect to see that you don't? What do/does the table(s) look like? I would never...

I assume it is getting the 4 digits from the query. If so, modify the query with something like: 'xxx-xx'&Whatever.Last_4 in place of the the portion of the query that creates the last 4 digits field.

I have no clue but I do have a thought. Would this work as your where condition: WhereCondition:="Social LIKE '*" & Me.Last_4 & "'"

The cool feature Excel has over Access is it's ability to record macros (which are VBA procedures in Excel). Just record a macro (tools menu), do what you want your form to initiate, stop recording the macro, modify the procedure in question to be a little more automated, and call your new...

This has all been done before. If you can't figure it out, why not try one of the fine starter databases that already work? You can modify them to your hearts content. The Northwind database should cover most of the functionality you need. It comes with every version of Access and SQL...

So in your form put the date in when you know it. If you want the system to use the current date, one way is to add an event handler to the date field something like this: Private Sub YourFieldName_Click() YourFieldName.Text = Date End Sub To get to this point, go to your form in...

Yeah, what he said.

Take a look at the attached. You need to step back a little bit and look at this. Keep it simple. Don't re-use stuff that doesn't work (delete it). Please notice that I set the referential integrity flag on my relationships. You should do that, though you don't need to cascade. Also, you...

Date()...same in Excel VBA. I am very confused as to why using Date() or Today() or Now() or Anythingelseyoucanthinkof() has anything to do with the persistence of a date. One might also wonder (as I do) why you're storing the current date and/or time every time you look at a table. If you're...

Can you upload a picture of your relationships window?

Good luck, Merrie.