Search results

So, if I understand you correctly, your form is based on a query that works fine by itself but when you use the form to view your records through the query, you can't view any records (you said that your form didn't show any previous records). Is this correct?

Are you working with a subform or a popup form or ...? I had a very similar problem when I wanted to add new records to a pop up form so I might have some insight if I know your exact situation.

This is exactly what Fornation told me to do when I had a similar problem: Try setting the default value of the linked field in your pop-up form to the primary ref on the parent form - Forms![MainForm]![IDField]. In other words, you should have an ID field on both records and you need to set...

The easiest format of picture to use is a bitmap (.bmp). Many programs can be used to create bmp type pictures and many pictures come in that format already. Each form (and each button) can support having one picture as its background. If you open your form in design view and access its...

Try it as an AfterUpdate event

I was just wondering if the scroll bars for your subform have been set to No.

When is this code being implemented? It would probably work best in the Form_Current event. As far as I understand, regardless of whether it is a continuous or a single form, the Current event is implemented with each new record so when you switch to record #2 from record #1, it will recheck...

I would put the following type of code into the Form_Current property: If IsNull(TextBoxThatReceivesValue) Then Me!TextBoxThatReceivesValue.Visible = False End If Hopefully this will work for you

Thanks a lot. That was exactly what I needed.

Thanks for the response. I actually went about doing it a totally different way that worked out quite nicely. The subform that I have is the kind that only shows one record at a time cause I like the look of it. What I wanted to do was to have a nice way to summarize the two fields from my...

Instead of having a subform on my main form (which I currently have and it works fine), I would like to use a command button on my main form to open up a form that does the same kind of job as the subform did (Have child records that link to the parent record). I tried to do this by linking the...

I had a similar problem with a combobox that I had. It turned out that it was not using the ID#, but rather the name. I would like to suggest that you use a query that concatonates the names together and you can also sort them alphabetically quite easily. Something like this might work...

I am not entirely sure that I understand your situation but I will hopefully provide you with enough info so you can work out your problem. I currently run reports on project funds that employees receive from large companies. Sometimes a report is run while some of these funds have not been...

Something like this might work: Private Sub ComboBoxName_AfterUpdate() If (Not IsNull(Me!ComboBoxName)) Then Me!NextFieldName.SetFocus End If End Sub You might also have to include the following (but I'm not sure so you should try the first part first): Private Sub...

I have a subform that has two fields. Both of these fields are comboboxes and the form is plain (doesn't have rows and columns like excel) so if you want to see all of the records you have to use the record advance button on the bottom of the subform. I would like to have a field on the main...

As long as you don't have subforms withing your main form you can do it. Go to Tools / Options / Keyboard and change the "Move after Enter" selection. You will probably want "Next Field". When you set up your tab order, make sure that the command button is last so when the last field is filled...

Thanks for the help guys. I really appreciate it. PS-- R. Hicks: You forgot an "s" on one of the SetWarnings! I ended up getting a Warning!

The problem that I am finding with the Undo method is that if someone enters data in the field and then removes it before leaving the form, the undo puts the text that they just erased back in the field! Very Confusing to say the least. I have made a delete query that will take care of these...

Hi Pat. Thanks for your response. Access did not like the line "Undo = yes" Just to let you know, I am using Access97

I have a subform that has 1 field. I have found that, for example, I enter in 3 records and then decide I don't need the last record so I erase the data, when I leave the subform (or go back a record), the blank record is left(still shows 3 records). Is it possible to check if the field is blank...