Search results

Please post the SQL for the query. Dale

The same way you link to a back end. External Data tab/Access/Browse Find your file/Click open/Select Link tot the data source and click OK. Dale

Start out reading the following information. Get your tables normalized. http://symplebyte.com/microsoft_office/access/how_to_normalize_data_access.html Then your query writing will be easier. Dale

Really, linq how do you make stuff so easy to understand. I worked all day and never got it right. You should have been a teacher. Thanks, Dale

I would link the table from the other database. It can also be done with code. Dale

My wife has a laptop with Windows 7. The other day I was going to make a new folder and new folder was not there. Right click/new/Briefcase?????????? Is this new? My desk top has new folder and briefcase. How do I make a folder on my wife's laptop Dale

The code you show just displays a recordset and has nothing to do with a form. I am not sure what you want to do yet or what you are asking. Your code looks OK as far as it goes. Please tell us what you are wanting to do Dale

Try the Rnd(number) function. Dale

As a rule of thumb I will have 2 forms for this. 1 to add and 1 to edit/review. It sounds like your form has an underlying query and that query is nor updateable. Sometimes you can get 2 tables in a query to update, anymore and I don't see how it is possible. Dale Note: 1 post 1 problem or...

I have tried a few times to get open args to work while opening a new form. I never could get it to work. Will someone tell me how this is used. Thanks, Dale

I saw a few errors at the top of your code. Dim db_contratos As Database Dim rst As DAO.Recordset Dim rst2 As DAORecordset Dim sql As String Dim num_rec As Long Dim count As Long Dim varReturn As Variant Dim datahoje As Date Set db_contratos =...

Do While ((Not rst2.EOF) And (count <= num_rec)) Do While (Not rst.EOF) If rst2![Nº Contrato] = rst![CONTRATOS].[Nº Contrato] Then rst.Edit rst![TRABALHADORES].[FichaAptidao] = True rst![TRABALHADORES].[datafaptidao] = Me.UltConsulta.Value rst.Update rst.Bookmark = .LastModified varReturn =...

On what line do you get the error? What version of Access? What are you wanting to do? Dale

The form is not open yet as you think of it as being open. http://msdn.microsoft.com/en-us/library/ff196808.aspx The above are the form events on open. This link is for form events. http://msdn.microsoft.com/en-us/library/jj714836.aspx Dale

You are saying that you have a table with check boxes set to yes/no. You are using these check boxes in a combo box. These yes/no check boxes are showing as -1 and 0 in the combo box. When I make a combo box with yes/no check boxes my combo box shows yes/no. Dale

Need to see your table structure. Dale

Can you show your tables. Dale

Do Until rs.EOF If rs![IndexNumber] = strName Then rs.Delete

field(Number) Number = the index number of the field within the record. Should remain the same as long as RST is open. Whatever EligCrit is in one record it should remain in all records. Dale

Strange. Indeed. Dale