Search results

Anyone got any ideas?

Thanks for your input. I've gone with a straight copy; list of 're-purposed' fields; updated labels on forms and reports. Not the greatest solution, but the reality of my life is - I don't have time, I don't have inclination and the second project quite possibly doesn't have the volume of work...

On a number of my forms, I have preferred or standardised text for responses under different circumstances (ie if "this" type "ABC"; if "that" type "XYZ"). I have saved these in autocorrect; however, autocorrect is machine based coding. If I type "STBC" I get "search to be conducted", but...

I have a database that works well for a project that runs at a State level. I now have a new project with very similar data tracking requirements, but it is a shire (county/province) level. The essential data is the same, but there are some obvious changes. For example, the original database...

Sorry, didn't explain very clearly. I burnt the BE to Disk 1. Linked my FE to the Disk 1 BE - now all my links say "D:\BE" Then I burnt the BE and my newly linked FE to disk 2, which I handed over to the client. The FE on disk 2 looks for the BE on disk 2. Disk 1 I threw in my hard-copy files...

I'm not sure I've set up my tables right, which may answer my question. I'm setting up a personal database (have rocks in my head) to track a bunch of home renovation projects. So far I have two tables - one for projects and one linked on the project ID for separate tasks. In tblProjects I...

I decided to burn the backend to a CD; link the front end to that copy; then burn both FE & BE to a 2nd CD. I guess if I had a re-writeable capability I could have burnt the BE, linked the FE, then added the FE to the same CD. I just put the backend copy in the file as a backup copy. Dave, does...

I've been asked to provide a copy of a database to an external client. The database is split, with the backend normally residing on the server and each user having a front end. I'm assuming my client won't have the Access knowledge to relink the tables, so how do I link them to the backend...

Thank you! Ctrl F6 - cycle between windows (ie tabs). Also handy, Ctrl F4 - close active window/tab.

Thanks Brian. I had a vague notion that two queries could do it.

It strikes me that this should be relatively simple, but I'm just not sure how to go about it. I have a report that consists of 5 fields, selected in a query. Depending on the user's purpose any one of those fields may be the best way to sort it. How can I set the report so the user chooses...

I'm running Access 2007, with my database set to show in tabbed view. I always seem to 'lose' objects in the window view. I'm an obsessive keyboard user; preferring to minimise how much I use the mouse. Is there a keyboard shortcut for switching between tabs? I thought perhaps it would be the...

If I have a table with three fields - Submission; Area; Contract #. Each [Submission] can have multiple [Areas]. Some [Areas] share a [Contract] across submissions. eg: Submission 1 - Area 1 - Contract A Submission 1 - Area 2 - Contract B Submission 2 - Area 3 - Contract A Submission 3 -...

I created a field in my query that works on iifs, casading through the dates - so if the first date is null, give me a text response "pending", otherwise, if the 2nd date is null etc etc. I have grouped on this field.

I have a table with four date fields - data requested [DReq], data received [DRec], search requested [SReq], search received [SRec]. (To aid understanding - we request data from a department internally to accompany a search request to an external department). I want to create a report to send to...

Although I fixed the problem by creating a new query, I will be saving this very handy tip for future reference. Thank you.

The datasheet would look like: Location Issue InsideDesc OutsideDesc A Humidity 50% 75% A Temp 24 30 A Other Factors Air con Stormy B Humidity...

The report does open from a button on the form, but the query doesn't. I was opening the query the hard way (looking for it in the list of queries). Even after closing the database down and reopening it the query was still showing the wrong information.

I have just had an occurence that doesn't make any sense to me at all. My offsider was entering information via a form. The information is used in a query to feed a report. He noticed that the data in the report hadn't updated. Easy fix, thinks I - exit the form to ensure the table is up...

I think I've attached a screen shot example of the type of data and format I want to display.