Recent content by Clut

Chuck Thanks again for your reply. It is now all clear. I am going to look into having Access automatically move the attachments onto the network drive before saving the link as I think my users will be attaching files from their local machines and I just know that they won't remember to move...

Chuck, Thanks for your reply. I think you've definitely saved me some headaches by steering me away form storing the actual attachments directly on the database. I do have one question regarding your last reply, if you'd be so kind as to clarify something further after already helping out...

Chuck, I'm about to start a project in which I could potentially end up in the same situation as you found yourself in. The project will be split into a front end UI with a back-end data store located on a network drive, both being Access 2007. As part of the data input, there are a couple of...

jzwp22 Your solution worked perfectly. I was trying to first get a list of all unique machineID's (the first table) and then perform the count in the second table based on each entry in the first. Your solution of count and then group by machineID seems so simple now! Thank you very much for...

Hi, I have 2 tables: 1) Machine ID's, which just contains a list of unique Machine ID's 2) Global Usage, which records when and where the machines are used. I am trying to create a query that pulls out a list of all machine ID's, and counts how many times those machine ID's appear in the...

Thanked :-)

Student, Thanks, that does the job fine. I guess it was a pretty simple question (hence the 'were you looking for something more complex' bit), but I'd just not used IIF before, and was unsure as to the syntax. Thanks very much.

Hi, I have a bunch of queries that run on a table of tasks to split them out into: a) Completed Tasks (task_completion_date field is not null) b) Pending Tasks (task_due_date is greater than now() ) c) Overdue Tasks (task_due_date is less than now() ) What I would also like is a query that...

This may not be the problem, as I'm not brilliant with SQL, but I did notice that in: FROM Transacions INNER JOIN you seem to have spelt the tablename wrong. It looks like it is missing a 't'.

Hi, I'm creating a database that stores troubleshooting information for a clients product. The client enters a brief description of their problem, and the database compiles a 'fault finding tree' for the user to follow to fix their problem. The fault tree initially consisted of 3 levels of...

thank you for the code, taking a quick scan through I already see the 'Split' function, which i wasn't previously aware of, which will make things much easier. I apologise if my previous reply seemed condescending, I didn't mean it that way, I was just looking for clarification as to whether...

David, Thanks for your reply, Wiki alone shows the prospect of several hours worth of bedtime reading material!!! I take it that your lack of reference to a specific function means that there isn't one available in access?

Hi, Before I get stuck into writing some code, I wanted to check here to see if anyone knew of an inbuilt function or feature that would do this for me. I have a table that lists problems we have experienced with equipment. For the purposes of explanation, the table is pretty basic, Id...

Gemma, Initally, there were a much smaller number of columns that the user could choose from, so even with most of them selected, the list box still had enough room for ample display, however as the database has grown the amount of data the users want to see has grown, hence lots of columns in...

You're right, it IS an awful lot of columns to display in a single list box. To counter this, I have created a seperate form where users can pick and choose which columns they want visible, as there are several different business lines that are each interested in different columns, and this...