Search results

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()...

thanks alot, the example helped tremendously i believe i had a space in the original formula and that caused the error. When i eliminated the space i was left with the focus issue and your example was right on the money thanks again Ricky

Nevermind, figured it out. I had to set the focus somewhere else in order for the statement to work thanks anyway Ricky

hey guys, does anyone have any idea on how to disable a button after the event has been run? I want to give the user a few options on a form. When one is depressed i would like that option not to be available any more. I tried forms![frmmbiinfo]![command10].enabled = false but i guess i...

ok, i am off to try a different approach... will check back with you guys and let you know how it goes thanks for the quick response

No, I have a table with employees and a field in this table called teams. Here i assign the employee to individual teams... Do you recommend i make a team table? I though of that at first but then though when an employee changes teams we would have to go to each individual team and reassign