Search results

Hi Bob, Thankyou, I think that must be working as when I run it, it freezes access and then crashes. Is there a maximum number of records access can handle? I have 15,000 maximum. Thanks, Chris

Hi, I ideally want to do it from a query as I want to use the results in a group in a form. This is what I have so far, but cant get the last part correct. It works up until the last Abb section Expr4: DLookUp("[Component Name]","TB-Abbreviation","[Abbreviation]"="[Abb]") I want to return...

Thankyou. I'm trying it now. Is there a general rule of thumb on when to use expressions in queries or reports?

Hi, If anyone can help me with this, it would be much appreciated. I have 2 tables in a db that costs Steelwork erection during constructions. I want a new field in TB-WAL-2300-Steelwork (cant attach an image) to search the first 3 letters of the Type field and return the Component Name in...

Thanks and I agree. Its fine saying use SQL but we know access and can use it. 1000 records maximum. 10 users that wont be using at same time all based 1 location. Access best bet?

We are developing a relatively small database (Maximum 1-2000 records) to track consultants we appoint and our IT department has questioned our choice to use access as they say it is unstable. Has anyone got any thoughts on this. Here are the concerns. 1.Where is this Database going to be...

Anyone got any ideas on how to resolve this? Thanks, Chris

Thanks for the speedy reply - impressed with this forum! A ProjectID relates all 3. Each Project has an architect appointed (or a number of architects) and each architect that is appointed has won the job through a tender. The hireachy is as follws Project Appointed Architect (Could be 5...

I think Ive already posted this but it didnt show. Really simple one (I think!) Want to track architects we appoint on construction projects and then which architects we sent tenders too. 3 tiers of information. Project to Architects Appointed to Architects originally tendered See attached...

Hi, Just wanted to introduce myself. Name is Chris and Im a new access user. Limited vb and sql experience or knowledge. Work for a multinational construction company based in London. Thanks, Chris.

Hi. New to access and definitely have alot to learn. Objective. To develop a database to log and track architects we appoint on our construction projects. For each project, we have an architect and for each architect we went to tender. We want to log that info. I tried last night to do this...