Search results

Hi, I think this is all the bits you'd need. I would keep this separate and look through it at your leisure (perhaps use parts or the general idea in the future?) Vince

For your info: Dynamic - allows updates - recordcount property disabled (returns true I think for more than one record or false for 0 records) Static - snapshot type - acts like Dao and allows recordcount - probably need to move last move first before it (just incase). Vince

Post your Sql...

Apparently yes... With a slight amendment to your Sql statement. Won't show in Query builder though SELECT fk1.[feeder key], fk2.[feeder], fk2.[mod] FROM fk1 LEFT JOIN fk2 ON right(fk1.[feeder key],5) = fk2.feeder; (I used left as a test - but seems to work) Vince PS: I didn't know this...

If you use code on, probably on a button press (although you can run from AfterUpdate)... Open a recordset with the table two and search criteria Check if you have record(s) returned. - If so put the first one into the fourth box - If not - tell user? close recordset dim rst as...

So this is an assignment, which means you have the tools you need (vb books tutor...) First up what are you going to do? I would write down a list of fields and group them together (normalisation) From there I'd shove it in Access and run a couple of tests with test data to see if the tables...

Table with venue details Table with lookups for suitability types Table (VenueToSuitability) with VenueID and SuitabilityID Then the form would need a multi-select listbox (probably) and possibly some code to store all selected items to the VenueToSuitability Table This is only one options...

What code do you have? Are the text boxes bound? Any other interaction from the user? Is it meant to display from one table and store in the other? Vince

Hi Bit late for me to post as you've already solved it but I wanted to chuck my 2 cents worth in. Couple years back I wrote (in access VBA) a text file reader that read any text file into a table (max 50 fields per row) so the developer could then manipulate the data easier (queries into the...

Tools>Database Utilities>Make MDE I think a 'save as' pops up and you save it to a new location. The MDE hides all code (its compiled) but doesn't hide tables. Needs access already installed If the pics are linked and not embedded then yes you need to include these.

Thoughts: - Read up on naming conventions more - don't use spacing in the naming of objects, nor special characted like slash - never ever use macros in Access - use VBA coding (read up on this if you need to) - the first form doesn't need to be linked to data (its editing a record?) - try not...

Sorry to post this as you probably won't like it... well at least initially. tblComponents ComponentID - auto - pk Compotent details (how ever many fields) tblAssemblies AssID - auto - pk AssCode - text - 20 AssDescription - memo AssActive - Yes/No - default yes tblAssemblyComponents...

In theory there is the web/data page option. No idea if it works. There is also via Asp (or possibly php) and displaying bit n pieces as required. Depends what you are needing to do with it, and how much time/money you have available to do things.

Forget the query returning duplicate info, if you are designing a report using access reports - then use the grouping function in access. I think its under the right mouse menu>Sorting and grouping Here you specify how to group and when, and also if you want a header/footer for each group...

Rethink the editting form perhaps so it won't allow new records and only allows the user to edit the selected record?

Function you'll need. - Rnd - returns a 'random' number from the seed (randomize) between 0 and 1 - Randomize - initializes You'd probably need to get all the Account numbers in a list/array/table/query. Store the maximum number of them into a variable. Then multiply that maximum value against...

Um... Not sure... I don't usually do bound things.. I do the harder VBA coded Sql statement way... You could change the rowsource... If you copied the main sql statement (the one that returnes records but doesn't have a where clause... or extra where clause parts) then add a where clause (if...

SELECT PL.productNum, P.description, SUM(PL.quantity) FROM PRODUCT AS P, PROD_LOCATION AS PL WHERE P.productNum = PL.productNum GROUP BY PL.productNum, P.description; The easy one, this is because when you use a group bby you must always list all the fields that are using aggregate...

Try changing the reference in the Sql statement to : In(forms!formname!txtbox) Then change the filter code to: If BuilderList <> "" Then BuilderList = BuilderList & "," & Chr$(34) & Me!lstBuilders.Column(0, BuilderSelected) & Chr$(34) Else BuilderList = Chr$(34) &...

Build the Sql statement up via code and use instead. Then you can have true, false, included excluded etc on the form and the code interprets it and creates as required. For example Searching for * (all records) means no filter required, but if you put a true in then a filter is required and...