I am not sure where ghostscript comes in, but it said cutepdf needs it to work. It is automatic in that I run the report in Access, and then to print it, I...
It certainly has helped me an awfull lot. So thanks to everyone on the forum, because I have learned from other's problems and solutions besides my own. I...
I'm looking for the best way to build my database, and I'd like your advice. I have a tutoring company, and I want to track clients, tutors, and the sessions...
FIrst you need more tables. SInce a tutor can teach more than one subject, you need a Tutor table and subject table. since the client needs more than one...
Abraham, It is presumed that you are ready with everything (including the crosstab query), except the report itself. Once you have a rough idea regarding the...
Hi, I suggest you add ID field to each of your tables. An Autonumber normally works fine for me. Suggested tables and fields: Tutors (TutorID, names,...
Thanks AD I was hoping I could dodge the crosstab query, but I will take the challenge. Abraham ... the crosstab query), except the report itself. ... of...
Bill- How is an ADP more "powerful" than an mdb? Yes, you get some table / view / SP / function editing tools, but they're buggy. I usually end up going to ...
Shawn- In Access XP / 2003, I'm able to link my contacts table twice, but that's not really your problem. I can also edit / insert / delete rows as long as I...
Here i post the code i use to link a txt file into an access database actually , i don't really "link" the file, since i look for a linked txt file ( i mean,...
I haven't tried this from Excel, but in Access if I already have a linked table, I would simply open the TableDef, change the Connect property, and use the...
John I'm not saying an ADP is better. They frustrate the heck out of me due to the form/report loss of functionality. And the ADP tools are about the same as...
that's true, no need to rebuild the table, unless the sourcetablename changes too, then, you do need to do something like that. but that isn`t the problem it...
Hello Bill, ... I'm sure I'm not aware of all of the differences, but I have seen some differences. ... Well I'm learning so what is most important to me is...
Bill- If you avoid using Access functions in queries and structure them so that all Access is sending to the server is the fetch request, an mdb performs just...
how can i make a cross table query allow me to enter data?? i have a table like this: HAS ( table name) ... IdCC IdRubro Cantidad example ( will be more clear)...
John I agree with you about fetching rows. My statement concerned manipulating data. Updating a hundred thousand of rows is child's play for SQL Server. Bill ...
Sorry, but no. A Crosstab query is a variation of a Totals query, and Totals queries are never updatable. To present the data in this way for the user to...
Bill- True. And you get the same performance from an MDB executing an UPDATE query or a stored procedure as you do from an ADP. All work is done on the ...
Another "just my opinion" - part of what I would include in graphic (and other) design would be determined by the target audience/users. If I were trying to...
Crosstab queries are not updatable. You would have to create an unbound textbox and do the updating with code, one record at a time. The SQL would look...
Hey Bill, so I figured out what was happening. The datatype coming in was not matching with my set data type, I had to change all my fields to Text--what...
Hi, First, I am more of an Oracle developer than access, however, I am finding Access more powerful than I originally gave it credit. Second, and more to the...
Good for you, Ines. Glad you got it working. Bill ... not ... record, ... numeric ... seem ... my ... it ... to ... check ... you ... are ... - ... (But ... ...
Richard The Expression column is not going to give you the column names. A better way to get what you want is to use VBA code and loop through the QueryDefs....
Absolutely. The best way to get at the MetaData for Access objects (particularly tables and queries) is through the DAO objects. Note that you can also open...
Kris- Thos numbers look OK - time is stored as a fraction of a day. Try specifically formatting the total as hh:nn:ss. But be aware that if the total is more...
Hi again, Bill, With the query successfully done and submitted, I'm back to trying to automate the text file generation. Two questions. First, where are all...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
