Search results

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

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

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

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

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

I believe this can be done with a query, but am having problems with it. What i have is a db with a table for employee another table for training items and a third table to tie them both together. These employees are divided into several "teams" (team 1, team 2 etc ...) The training items...

Hey guys, I have a problem which i have seen discussed here but none of the solutions seem to work for me. What i want to do is simple. I have a form named frmName, this stores last name and first name. I have another form named frmAddress this one stores last name and address. What i...

not sure where this should go so i stuck it under reports. My db automatically exports my reports to html format using a template i designed. The problem is that the size of one of the fields is too small. I changed it in the template but still the exported html report has the original small...

Hi, My problem is that i have 4 reports that are generated with a macro. We would like to have these reports exported to HTML format. I know i can do it manually, File, export, etc... but is there a way i can have a code or macro do this automatically for all four reports at a push of a...

first of all let me thank all of you for your continued support through my struggles with access. Sometimes i dont think i will ever get as good as i would like to with it but i keep pressing on here's my latest delima: I have 4 areas with 7 teams per area. Training is assigned to all or...

Hey guys, a quick question. I have a form called "FormA" within that form i have a tab control and one of the pages is called "Page1" inside that page1 i have a subform named "subform1" and finally inside subform1 i have a field named "field" what would be the correct syntax to reference...

What i have here is a training db. It tracks training for the FAA. Problem is there are 6 teams of employees and not all teams get the same training items, sometimes everyone get it sometimes only team 1 and 3, etc... i decided to do this with a check box so when the data entry person enters...

Not sure where to put this so I placed it in the general section, hope thats right. My situation is I would like to store a different data instead of a yes/no with a check mark more specifically, when the check box is checked i would like to store the code "0100" in a different field. I...

hi, I have a database that tracks events that happen periodically. My problem is that we need to generate a report that includes data from the latest event. For example, we genereate a "Tapetalk" to controllers on different cycles, some of them every 6 months and some might be monthly. Also...

I have a form, within this form i am using a Tab Control to allow me to have several subforms within that main form. Works great except when i try to reference a control within one of those sub forms Main form: frmStudentInfo subform on a Tab Control: subfrmParentInfo...