Search results

My suggestion would be to fix the table problem. Dale

What you ask is possible I think. The problem would be that you can not use the same form unless the field names were the same. If the field names are the same then your tables are NOT normalized. Back up and look at your tables. Dale

I found you needed to uninstall the old version first, then delete the FE or the database. The install then works OK. Dale

Your tables look ok, Your relationships on some look backwards. A few examples are; tbl_Location. You can have only one location per user. You can not enter a user without first entering a location. Put the user_ID in the Location table. Same with tbl_Years Of Experience, tbl_Area of Experience...

No, I don't think you can. No way for the command button to know what you want to do. Dale

I solved this by storing the Total sold price. I don't think this is recommended by anyone however, I did not want to write a lot of code. For me it solved several problems of refunds, taxes and future sales. Dale

Try a Text Rich File. Worked for me. Dale

Dim rstEMails as DAo.Recordset Dim rstFile as DAO.Recordset Dim DBS as DAO.Database Set DBS = currentDB Set rstEmails = DBS.OpenRecordset("Beldenemails") SET rsFile=DBS.OpenRecordset("PutSomeTable/QueryHere") Close rstEmails Close rstFile Close DBS Set rstEmails=Nothing Set rstFile = Nothing...

You don't want the form to lose focus UNTIL the NameOf Order field is typed in. Correct. Then you say the form loses focus AFTER the field is filled in. I am not sure what you want. Dale

Unbind your combo boxes. 2nd box would be something like , WHERE tblCampList.CampID = The ID of your third form.; If they are linked by ID and NOT name. Dale

FYI. Form Events if you don't have them. http://msdn.microsoft.com/en-us/library/ff835965.aspx I would look into the Undo command. Dale

Sorry to differ with you, however IF a database is properly constructed the users need not know anything about Access but how to enter and retrieve data. Dale

Try, Me.YourSubName.Requery Dale

Start by looking for Format$() on the report and in the code. Dale

I would start with a query that filtered the customers with a debt. Bind the DebitForm to this query. Add the new button to open a form the read all records. Docmd.Openform "DebitForm" Dale

The first combo box is filled with the data to filter the 2nd combo box and the 2nd combo box is the filter for the 3rd combo box using the WHERE clause. To be more specific we would need more information as to what data you are using and exactly what you want to filter. Dale

If your tables are set up properly this should happen automatically. Take a good look at your tables to make sure they are well normalized. Google normalization. Dale

Your table structure sounds like it is way off. Google table normalization. Your student information should only be in one table and related to the tables. Dale

You can try putting Is Null as an OR in all of the Filtered fields. Forms![frmLBT_db_Tool]!cmbName Then under this (OR) type Is Null. Dale

Try this. SELECT Count([ACD-C-DataSourceExport].Field2) AS MyCount FROM [ACD-C-DataSourceExport] GROUP BY [ACD-C-DataSourceExport].Field2 HAVING ((([ACD-C-DataSourceExport].Field2) Like "2313*")); Dale