Search results for query: *

I am looking for device(s) that would let someone scan a document from a vehicle (or fax) using a mobile phone or pda. I have been searching through the Internet but have not been very successful. Thanks, MM

I tried using the self join and also a subquery. Both resulted in giving me a colum with the id of one less, however the odometer reading was the same

I am trying to calculate the difference between to values either in the query or on the form. The data is as follows: Id Odometer Reading Miles Driven 1 3081 ? 2 3481 ? 3 3751 ? This data is part of a table which relates to a...

This worked beautifully!!!! Thank you so much. You have also answered another question I had (though I didn't ask it! you must have read my mind [smile]). My next task was to figure how to use style sheet and bypass the "" situation. Again Thank you.

I am trying display information from two related tables out of a database. After creating an inner join query, I use the following to display the information MyArray = rsmastdetail.GetRows() Const Mydegree = 19 dim vartemp vartemp = 0 Response.Write("<p>") For x = 0 To Ubound(MyArray,2) If...

This worked wonderfully! Thank you so much. MM

Thanks for the quick reply. I tried that but received an "invalid Procedure call" error. I added the following statement to the criteria option of the query: Left([insturl],InStr([insturl],"#")-1). The SQL statement looks as follows: SELECT tblinstitution.insturl FROM tblinstitution WHERE...

Hi, Is it possible to create a query other than using the trim function to remove some unwanted characters from a string. I have a delimiter in the middle of the string (#) and want everything removed following the delimiter. The number of characters before and after the delimiter vary. Thank...

thanks for the quick response. I am not sure if I need to concatenate. Here is a tblBib Id name abstract topic topic topic 1 baker xxxxxx t1 t2 t3 here is tblTopic Id topic In order to have multiple topics, will I have to create multiple colums, or is...

Hello, I am trying to create a database which keeps track of bibliographies. Each bibliography is a table row and has one or more topics. The topics will be listed in a different table. The goal is to display the bibliographies related to a specific topic when a users clicks on the topic in a...

What do you mean by this, johnwm? Not sure I understand.

Thank you. The max id worked. :-D

Hi, I have a form set up using dreamweaver. When the form data is submitted, it is added to an Access Database, which uses the autonumber function for this particular table. I would like to display the particular number that is assigned to the new record just entered on a confirmation page. Is...

I tried to follow this and I understand what it is supposed to do, however, I get run-time erroe 2427, "you entered an expression that has no value." It is referring to txtCount. I did set the control source to =1. Anyway I can bypass this problem?

I am trying to use an unbound text box in a report to display comments from a query. Sometimes there are no comments to display. In that case I want to display the message "No Comments were made". First I used this: IIf(IsNull([not_cur_there]), "No Comments were made", [not_cur_there) When...

Is it possible to use data from MS Access and form frequency distribution tables? If so, how?

Yeah, I know how to do the queries. Was hoping though I could get around joining all together. :) Thanks for the help

I used a couple of group headers and that seems to be working well. Thank you very much

It is coming from Access. I would have to put the conditions somehow into the queries? Is it even possible to link to more than one query or table from a single word doc? I am sure these are very elementary questions but I have never really linked two sources together like that. I appreciate any...

How do you do that? The only thing I know so far is to use the toolbar option where it allows you to insert a single if-else statement. I am sure I will have to add some kind of code somewhere?