Search results

I thank you all greatly for your input and help. I had totally forgotten about this post. In the end the "government funded organisation" that I was desigining this system for, was restructured, and the new admin opted for a system utilising cloud storage and based on SAP, with a web interface...

Yeah too bad this is a charity job. Have a family member in the Fire authority here, and the Government want some pretty hairy statistics. I made the mistake of saying "That's easy" Long story short, instead of a weeks work for a fortnightly report, they do it at the click of a button now...

In the end the client decided they liked the popup method better, as it updates the every record in one quick run, as opposed to the original idea in which the client had to select each drop down manually. The comment from the client was "OMG you have just saved me 3 days work" So for that...

There is always a way, it's just a matter of ingenuity and a lot of code. Anyway I have come to a more viable solution anyway. I DID manage to make things work as I had planned - thanks for all the suggestions, the last one was the trick. However in my quest for temporary solutions, I made a...

Hmm, well that does achieve my end objective, but not quite how I had imagined. The solution has actually added a trimmed down listbox next to a textbox to give the appearance of a combo box. I had considered a listbox, but not quote in the arrangement. I'll give it a go and see if it will do...

It is, and hence why I have not added a hidden subform and grabbed the values from that. At present I have just added a small "suggest" button beside the box, that launches a new form briefly, figures out the post code, and then dumps it back to the original control using a global variable.

A little update that may assist in explaining what I want to do: I am half way there. I currently have the drop down box displaying post codes for ONLY town names that exist in the main table. I used the following SQL in the ROWSOURCE property of my dropdown box: SELECT [Pc-book_Query].ID...

Not really, I only have one combo box. I have found a temporary solution to this for the time being. I will try to explain myself a little more clearly. I have a textbox and a drop down. the textbox contains a town name. the dropdown contains a post code. to populate the dropdown, I used...

Not exactly. there are Two tables involved here. Table 1: contains various personal details including a town and post code. postcode is displayed in a drop down. currently, drop down is populated by a second table (or query of that table) I would like to filter the drop down contents to...

Hi, Currently I have a form that displays details of person, and location. among these fields I have a town name and a postcode field. I have a post code table, and a qurey of that populating the rowsource of the drop down box, for post codes. I would like to be able to take the town name...

It adds a duplicate table, and appends a number to the end of the original table name. Aafter some research, sparked by a previous poster, I have come to understand that this is an access feature. Quite irritating that there isnt an overwrite option.

This database is quite complex and the individual tasks many. I have excess of 200 objects in the database. It carries a variety of data, and is used to generate statistics required by an overseeing government agency, as hence I have to be careful what I mention about it's workings as I am...

Hi, I'm currently working on an ongoing project that requires regular updates to the forms and code of a database. I would like to be able to click a button and import all the tables from the old version to the new one, and OVERWRITE the data. I may add new tables in between versions, so...

Note a Problem, thanks for the time.

Nevermind - I managed to do it with a single query. i just added this line to the Criteria on my first query and it returns both the first and last date only. Note my table is: PROJECTMEASURES Query1 and my Column is: REPORTDATE =DMin("REPORTDATE","PROJECTMEASURES Query1") Or...

In trying to create a summary report for min/max (using the wizard) I have found that it will not create a min/max summary for dates, only number fields. What you have described is what I am already attempting to achieve. My question is rather HOW return the max and min. I would prefer to be...

Hi, I currently have a query containing a list of dates, among other things. I would like to filter by criteria, the first and last record; or the earliest and latest dates. I am sure this is possible, but my brain has not quite nutted it out yet.. Thanks in advance.

Hmm, handy tip, shall remember that one. took me quite some time to export everything out one by one. Thankyou microsoft help - whom said i should do so one by one.

Have come to a compromise, just spent the last hour exporting 200 odd tables, forms, queries, reports and modules to a clean database - all appears ok now, but it's midnight and I'm seriously over it. I'll test more later and report back for anyone who sees this post.

Hi, I'm currently working on a major database, and it is near completion. Today, while adding a new form, with a few buttons and a couple of docmd.openform commands, I received a "file not found" error while trying to rename it. now this has spread like a virus to the rest of my database. I...