Search results

There seems to be an awful lot going on here and I'm not sure that i am following all of it. Basically once you have got all the info on the form you then have to save it out to one or more tables. Because it (or some of it) is unbound you are going to have to save it thruogh one or more...

Just for my own education! If there are 14 fields from one source then why not use this as the form source? You can still update theother 51 as you do at the moment.

Still can't actually get computer name out of environ. Decided to solve it my putting a text file on C: drive of all my machines with info which Access needs about the system. Clearly any computer without such a file is a demo. Thanks for your help. The Environ function is a great addition to...

This structure looks like just the thing but don't I have to put something into environ("computername") for it to work? At the moment it just returns an empty string. I looked at the Access help files for environ and they seemed to be the right sort of place but could not find out how to get a...

Can anyone tell me the easiest way of identifying which computer an Access database is running on. I have a demo database on portable media and need to be able to tell if it is running on one of my (3) computers or on someone elses.

What is the horizontal dimension on your time sheet?

Sooner or later any large database will hit capacity problems as it grows. Keep the structure simple with a few large files which are correctly related. This will be the easiest for porting to new software/hardware when you reach the limit on the existing setup.

Sorry about not answering earlier - been a bit tied up with other things. Have you set up the relationships between the tables? If so it should be easy to get the queries going. The tables look OK but then I don't know what you want to see as a report etc

I can't help with the specifics of which version to use but here are some thoughts which may be useful. The new version of Access will probably tie in with the new version of Windows which in turn is designed to make full use of the newer and more powerful computer chips. I assume that you are...

Jool, Sorry that it was not clear. I think that the Access intention was that you would create a report in the format of the email you wanted to send and then use sendobject to send it. I have shown a form with a single text instead.This should work if all the Internet hooks are set and can be...

The reason for the error message is that you can only send a specified access object with this command. As the object type and object name are blank it cannot find them. You will have to enclose your message in an object. I would pick a form with a single text on it. Save it with an...

I have an Access Database on a machine with the Windows date set to dd/mm/yy. All the dates appear on forms in this format. However when I filter on a date field and then look at the filter the date is in mm/dd/yy format. If I try and set an equivalent filter in VBA from another date field it...

I would look at what sort of data might appear in the standard report. Official figures are often subject to "convenience" so a good report will give some sort of range to a data point. E.G. max min, average, preferred single answer, number of sources. This may be much heavier than you were...

A relational database will be much better than the flat file - eventually. It is clear that it is quite complex so by the time you have finished you will know quite a lot about databases. I suggest taking things slowly. Keep your flat file and separate out one chunk of data at a time. Start...

There is confusion in this discussion between what data is actually to be stored. Do you want to create a track of item prices history or a track of supply orders (both is possible but not in one file). The key to success is NEVER depend upon a calculation in a history record. Item price...

Just had a look at this thread. Aren't you trying to solve the problem in the wrong place? Surely if you group all the employees in the Outlook address book then you only have to address the e-mail to a single item - the group.

I have seen many inventory systems in use (not specifically Access). The most common error with internally developed ones as opposed to bought packages is that they do not record manual stock checks. It is good to track numbers in and out but product does disappear in any warehouse. If you do...

I know nothing about an E room but you could try just linking from Access to the Excell. This would leave the existing system totally in place. You could treat the data as Accessdata and formulate nice reports etc. Once people start to see what results you get then maybe they will want you use...

estimate versus actual Sorry I was not precise enough. There should be only one reading per period. The estimated field is not to hold a reading or to permit being calculated. It is a binary field which distinguishes between an actual reading and an estimate. Most of the time it does not...

This could be tricky as I don't think there is enough detail to answer definitively. Stile this may help. When you split a table into two you need to establish the relationship between them. If you have done that then your original query will just take the same fields but from two tables so...