Search results

I don't know. I also Googled it and got very confused. Can you upload you databases? Dale

You may want to read the following, http://symplebyte.com/microsoft_office/access/how_to_normalize_data_access.html Dale

try vbCrLF Dale

How are you telling Access what to select? Dale

What version of Access. google "access error 1002" if you haven't already. Dale

I don't use Tabbed Documents because of this. I change most of my databases to Overlapping Windows. This gives the use some control with the size and location of the forms. Dale

I would split the table. Separate the husband(partner A) and wife (partner B) I see many problems down the line if people are not married or divorce and get remarried. See http://symplebyte.com/microsoft_office/access/how_to_normalize_data_access.html Dale

I would suggest converting this to VBA. Easier to troubleshoot and work with. Dale

tbl_p_stats.i_weekending, tbl_p_stats.i_sacat and _p_stats.i_complexity needs to be in the Select part of the query. I THINK. Not real sure on this. Dale

try, SELECT count (Contacts.Name, Contacts.Address1, Contacts.Address2, Contacts.Town, Contacts.County, Contacts.Country, Contacts.PostCode, Contacts.Telephone, Contacts.Code)FROM ContactsWHERE (((Contacts.Address1) Is Null) OR ((Contacts.Address2) Is Null) OR ((Contacts.Town) Is Null) OR...

what is text and what are numbers. The text needs to be delimited or surrounded with quoues. Dale

whatever works for you. Dale

This type of math and testing would likely be better carried out in VBA. You would be asking a lot from a query to do the checking. You would need to check the year to make sure the year is not over yet. Check to see how much vacation time an employee has coming. Check to see if the employee is...

Sounds like you need to normalize your tables. Take a look at this. http://symplebyte.com/microsoft_office/access/how_to_normalize_data_access.html Dale

srtComboN = Nz(Me.txtNameF,"") & " And " & nz(Me.txtSpouse,"") Dale

The problem lies here, SELECT CONTRATOS.*, TRABALHADORES.*, DELEGACAO.* Multi-tables in a query are seldom updateable. Also looks like your tables are not normalized . Dale

I had this problem a few times. It does take some code to do this. I started with the oldest invoice, applied all payment to that, any remainder went to the next one and so on until the balance was zero. The math is not as bad as it first appears. Dale

Look into the Field.Name property. Dale

Well something ain't right. besides wanting 90 queries what is it you are attempting to do? Dale

Side note here, the linked table does not have to be related to the other tables in the database. It would be nice if it were but does not HAVE to be. Dale