Search results

Hi, I had a look and changed tables, relations, form, recordsources and vba... The problem was partly in the table structure and the relations with foreign keys etc. In the form itself there were similar problems and the dropdown boxes needed to be bound, set up and a bit of coding!~)

Here's a quick example... and there's some other samples on my website!~) Just remember if you want to reference a form from the vba editor, then the form has to have the form property 'Has Module' = True

It's a problem testing without doing a bit of development and I'm strapped for time, so I'll rewrite your solution instead... Create a module and enter the following: Public Function BravisImport() DoCmd.TransferText acImportDelim, "Bravis Importspecifikation", "Bravis import"...

Det er bare ok!~)

Is it possible that you can upload a copy so I can have a look when I get a moment!~)

Private Sub lstSupplier_Click() Me.lstCustomer = null Me.lstCustomer.Requery End Sub

If you open qry ProjectRecordsStagesOfficers and click on the grey area then you get the property sheet for the query. Change recordset type from Dynaset to Dynaset (Inconsistent Updates)

Sorry I was looking at all that cross posting stuff and lost track!~) I will have a quick look..

If you upload your db we can have a look at it!~)

A good start would be to start entering the data in an Excel spread sheet. That will help you enter the data in an uniform way which is needed in a database. Later it's easily changed into an database. In Excel you make the first row the headings and then when you enter data keep the format...

..if you don't want the tabbed version but the form size you designed, then set document window options to overlapping windows...

file>options>current database: 1. Display form (chose your form) 2. Display Navigation Pane (untick) 3. Track name AutoCorrect info (untick) If you want to get back into the design view, hold down shift when you open the database.

Do you know about designing a relationsdiagram on a piece of paper?

...by the way before this works you have to go to design view on HarvestInfo and set HasModule to true...

You create a button and cancel the wizard. Right click on your button and get to the code generator. Enter the following: private sub NameOfYourButton_Click() docmd.openform "HarvestInfo" form_harvestinfo.CID = me.CID form_harvestinfo.Permit = me.Permit end sub I have presumed that the fields...

In your case you can doubleclick on the sumofincome box and the table appears. Then just change the columnheadings in the table!~)

format recognizes mm, dd and yyyy if you want to enter characters not recognized you put \ in front of it and format will just "print" it... So in your example TxtStartDate would become #mm/dd/yyyy# and the #'s is showing it's a date, like "text" or 'text' and in this case #date#. Therefore you...

I deleted the message... it was incorrect I just tested... I have had the same issue and solved it in the query and I don't know if the situation Bob is describing was at large. The report was showing that little funny square when I tried to call a function!~)

Resolve it in the query!~)

The suggestions are implemented in the attached db!~)