Search results

I just discover a little something here. I remove the relationships that were there and I changed the txtboxes to comboboxes and set the record sources to for the comboboxes, so I really don't need the relationships that were there. Check it out and see what you think. On you form, change the...

Great, glad it is working for you. Good luck with the rest of your project.

Thank you for the attachment, I check the cascade upate and delete for all of the relationships. That is the best I can do right now, unless you can send the form and, if the record source is a query, I would need that also. Other than that everthing looks alright.

In the tooling drop-dow of the vb editor, select references. See if DAO 3.6 library is checked, if not check it. That loads it into the dbase for use. If it was not checked it will cause a world of problems, which will immediately clear up when you check it. hth.

Strange, it works on a half-dozen txtboxes on my form, I am daffled. Stupid question here, on the above problem, you do have the DAO 3.6 library checked in the reference pull-down don't you? I sometimes miss that one. hth.

This is where relationship come in to play, make sure that referential integrety is check, as well as cascade update and delete. Also make sure that master/child relationships are set. This is all assuming that the tables are normalized correctly, but not manidory, just very helpful. You...

Thank you Pat for the little lesson. I always thought of SQL as a simple query language and nothing much more. Learned a little something here. Thanks.

A form is a window for the table's data/records, it can create new records, edit existing records and delete records. hth.

Your welcome, glad I could help.

I think the problem should probably be in the master/child or in the table relationship. Because you can change customers, but the trouble is in the subform area. In the table relationship, is the referental integrety checked? How about cascade update and delete? I am assuming there is a...

Have you check to make sure that the master/child link is properly set up. hth.

Interesting, I use a lot of .snp charts and reports to both print and e-mail. Well, I think what you are looking for resides in an API procedure. That stuff is increditable, I am not sure but I think it even severs coffee. I don't know API, the only time I used it was in a dbase where I was...

The gaspipe is probably an easy out for the new boss, but Access is easy once you catch on. So let's try Q1, link the the Pkeys, even if the one in the subform is invisible, and you make visible what you weant to see, thru the properties of the forms controls. Q2, comboboxes are the fastest...

I am not sure this will work in Datasheet, but it does in Continuious form. In the form's OnCurrent event, try something like: If Len(Nz(Me.YourControlName, "")) = 0 Then Me!YourLabelName.Visible = False Me!YourControlName.Visible = False Else Me!YourLabelName.Visible...

What is, very simply put, happening is you opened one record, via the Customer selection and you have not save it and closed it and then you are trying to open another. Is that kind of clear to you? A simple cure is to add a cmdButton to the form, cal it Save and then add a second cmdButton...

SQL is a query language, it is meant to select and filter and merge data. VB code is for what you want to do. You can do a lot of thinks in VB code including running SQL code and recordsets and set all kinds of properties. hth.

Sense you are new at this, always use the KISS method. Don't over think things. Most relationships are one-to-many and there are a couple one-to-one relationships. Many-to-many relationships ar rare, thank god, they can be a real pain. I have not seen you tables so it is a little hard to...

In the control's AfterUpDate event, try adding: Me!YourControlName.DefaultValue = Me!YourControlName.Value hth.

You could also just have entered that value in the control's DefaultValue. Just my two cents her.

Your combobox is doing exactly what is should do with Null. Null means nothing or blank, no data. What you need to do is add and ALL to the combobox list. Then check this out: http://www.mvps.org/access/forms/frm0043.htm It is another good reference site. hth.