Search results for query: *

Thanks for the thought, I will look into it though. Might be a way for Excel to access the sharepoint and pull in data. At least it is worth looking into.

Is that possible with the database being on a sharepoint site?

I have run into an issue that has me really confused. I would like help if anyone is able to help. I have a sharepoint site with an access database one it. I am able to create a query that ask for parameters and it works great. The problem I am having is when I am trying to print the query. The...

I see the confusion there. That last part was an weak attempt to find only the record in the table that matches the Combo box selection that has a null value. I have created a subform and that seems to be a solution for the issue at hand. Thanks for ya'lls input.

The second form record source is the table and has an unbound combo box. The search is done by the following code. Dim rs As Object Set rs = Me.Recordset rs.FindFirst "[Student ID] = " & Me.Combo5 Me.Bookmark = rs.Bookmark If [Time Out].Value <> " " Then rs.FindNext "[Student ID] = " &...

I have a table that has 7 fields ID(key), Stud ID, Stu Name, Subject, Time In, Time Out, Date in. I have a query that pulls only records that have blank "time out" field. I have a sign in form, that creates a record with all the information except time out. Form two has a combo box that pulls...

I have 1 table and 1 query and 2 forms. I want 1 form to update have of the table and another form to update the rest of the table. Right now I have everything working properly, except the 2nd form. When it is used to update the table through the query, it creats another record that contains...

I have run into a problem with a database I am working on. It is a simple log in and log out database. The way it works is a form creates a record for logging in. Then another for updates that record when you log out. The problem I have is that everything is working, except I get a record with...

Thanks again for the help. I think I understand it now. I am going to try and work out the coding for it. Again thanks a lot.

Thanks for the clarification. I am working with java, so classes is what I am after. Thanks again for the help. The next thing is, anyone explain how to randomly pick from a list without having duplicates. I am confused on how to "scratch" an array item from the selection list. Really do...

I am having trouble understanding how to create a script on creating a schedule with conditions. I am not asking for anyone to provide code, unless they just want to, just help me understand the concept so I can learn to code it. Thanks for any help

Everything you have supplied works just as you state and fullfills what I am needing. I have to mail each individual a letter, inside which will have the roommates with a phone number for each roommate. I don't want it concatednated with anything else because the address is a home address for...

Skip you make it look easy. One last question. How do you control where to start coping the information from for the roommates. The only reason I ask is because I have the address I have to insert after assignments for the mail merge, but don't want it concatenated with the other data. Thanks...

My apologies. I like the comma between the last and first name only. As for other columns of data will I will be concatenating the only data is the address of each person, but it isn't concatenated. It is just for the use of the mail merge. Thanks again

Skip, I was able to step through you code and found where it was entering the comma. I like to have the comma between the last name and first name only, but after looking at the code, it will put the comma behind all the data present. I don't see an easy way to change it so I am just going to...

Found the problem, I had end sub before the NextRow. Thanks for the help. I also have been trying to figure out how to remove the comma before the phone number. It is displaying it with: LName, FName, 999999999 Which is fine if that is what I have to do, but thinking about grammer on the...

I will recopy everything again. I do have that at the bottom of the code. Will let you know in a minute or two.

Label not defined. sorry for the mis wording on error.

Skip, I am working with your code and I am getting a Label not found and this part is highlighted: GoSub NextRow I have double checked and the code is letter for letter to what you typed. Any Ideas? Frankcpl

Lionelhill, That does make since. The data that I am using is for a campus dorm. It isn't for a huge scale thing. The way it works is I get an excel sheet that has everyones infor and room numbers. I then do a mail merge. What I am trying to do is simplify the mail merge by gathering all the...