Search results

Was this Article ID number suppose to help me answer my question? I typed the number into search but that just sent me to the reports page. Is anybody willing to give me a little more help? thanks

I have a report with 2 fields: Grouped on [Name] Under Detail [Room] The output looks like this: John Doe Rm 100 Rm 200 Mary Jane Rm 100 Rm 300 Rm 400 Is there a way to make it look like this? John Doe Rm 100, Rm 200 Mary Jane Rm 100, Rm 300, Rm 400 I...

I have a date/time field on a form. I have a calculation that adds number of days to Date() and enters the answer in the field. Example:Date()+30. If the answer comes on a week end, can I get the date entered to be the next occuring week day? Thanks

Roy-Vidar It Works!! I have been struggleing with this for some time. I am sooooo happy I finally got it. Thank you so much for your time. Erin

Hi all you helpful folks, Can anybody tell my why the code below does not work? When I click the cmd button, the only msgBox that shows is the one that starts Didn't work. I want to be able to show the MsgBox stating there are no records. Help?????? Private Sub Command30_Click() Dim db As...

Thanks. But Since it is now a table instead of a query, I am having trouble figuring out how to tell Access it is a table. Dim DB As Database Dim rs As Recordset DoCmd.OpenTable "Current Schedualed Trans" If Not rs.RecordCount = 0 Then MsgBox " "

Thats the question. How do I determine if a query has any records. Change: I'm now looking at a table to see if there are any records.

I want to run a query and do something only if it returns a record. so far: If <the query returned a record> Then Do something, I got this part figured out. Else quit doing anything End If

Thanks for the idea. I could not get it to work. Any other ideas?

You people are so excellent! I have a query where I want to select records where the name starts with a range of letters. The criteria on the name field so far is Like "[A-C]*" So far, so good. Now I want to change the range to something else like D-G. I want the user to type that in and I do...

I have created a Crosstab Q. I have a Code field that I need criteria for. The Code field is also the column field, so I added the Code field again, set the Grouping to Where, and typed in my criteria. So far, it works. When I try to put a parameter in the criteria referenceing a text box on a...

Background: I have a table called 'Students' which is the 'one' table. The many table is called 'Term'. I am splitting the 'Term' table up into 2 different tables because I am importing term info into the 'Term' table, and there are 2 different times during the term that the data gets imported...