Recent content by Muzicmn

thanks works great, can you tell me what Chr(13) & Chr(10) stand for I believe one of them is a carriage return?? thanks again your a life saver Ricky

Is there a way to populate the value of a memo field with the push of a button. What I am trying to do is have a few default items that can be automatically entered into a memo field. When I attempt to change the value of the memo field either thru the wizard, macro or by using a simple code...

When entering data in a memo field i would like to be able to hit the enter button and go to the next line instead of tabbing into the next field. Is there anyway to accomplish this?

I understand that trying to edit a query from multiple tables will not work as the link to the record is "broken". However, is there a way to filter a table and edit the results in a form view. In other words my table holds data for 42 supervisors. I would like to get a form view of the...

Thanks for the reply. I was thinking about doing something like that. Thanks again Ricky

Sorry if this is an elementary question, but here goes. What I want to do is have Access run a query based on the user name "taken from a login screen". That query will return some values such as what team the Supervisor is responsible for, what days off his team has etc... This information...

What I need to accomplish is an alert if a query finds any records. In other words, When the main page is loaded a query will run in the background. This query is looking for any records that need to amended within the next 30 days. What i would like to do is if the query finds any records...

Sounds like what i have to do, i was hoping there was a way to automate the process. The problem really lies in the fact that this program is being run on thumb drives and depending on the configuration of the computer its plugged into the drive name changes (in some instances its drive e...

Not sure where to post this question, so I put it in the general section, I have an old db that i would like to import into a new be db of a newer version i wrote of this db. Is there any way something like an append query will add the records from one database to another? or do i have to...

I assume its a format error but what i am trying to do is run a macro which will open a pop up window if there are no records to display. Right now if the button us pushed and there are no records to display I get the debugger come up.... I created a small popup window alerting the user that...

I guess i am in over my head here. I understand the concept of what you guys are talking about but not sure on how to write a code that will accomplish that. I was going to try to create fields (not visable) and place them on the form and when the update button is pushed have access place...

thanks for the tip, will give it a try Ricky

Thanks for the response but my problem is a little deeper than that. The form I am trying to get data from is a continous form and i would like to use all the records that were filtered as a criteria for the query. For example, I am using combo boxes to get me a list of records of all...

Hi, My situation is hard to explain but i will give it a shot. What i have is a db with employees and its being used to track training sessions. These employees are split into 6 teams and those teams are split into 7 teams each. I have written two queries, first asks the user what team to...

Hi, what i am trying to do is save a record and then apply an if statement at the push of a button. I am sure its easy to do but cant seem to figure it out. When i apply the following code i get an error saying "expected end sub" How can i get around this Private Sub Command25_Click()...