Search results

thanks you, both variations worked. i am aware that the data isnt the best but its a small part of a large live system. The particular query that the data is being counted from is used to display which analysis needs to be completed for over 20 different tests (the columns) and can be for as...

thanks for the response, i put your code into the module and set the sql for the query as: SELECT "Y" AS [The Value], CountValueInColumns("Y",[Mois], [DGA], [BDV], [Acid], [PCB]) AS [Count Of Y] FROM Tracker_List; that provided a long list with Ys in the left column and numbers (presumably...

Hi, I have some data in a table with gives a value of "Y", "C" or blank for ~20 different columns. How do i get the query to count how many times "Y" appears in each column separately. I can get it to do it for one column by adding the field to the query twice and adding a Sum Total with...

Sorted it....you can change the Control Padding to none and it removes all the gaps so appears just like a table. Thanks for your help

That's almost there. Works fine but it has spaces separating all the boxes. Can you align them all "left" so the boxes (cells) are directly next to each other, like a flat table rather than individual boxes?

Hi, I have a subform to display some data on a report. The fields are all set to "can Grow". The screen shot below shows the section of the report in print preview (only showing 1 item). if theres a second item it just displays them like a table. The Description field is a large text field and...

Spot on that, did the job perfectly. Thanks you very much!!!

Hi, it is relevant as I am trying to create a report which matches in with the companies current system and that requires each record to be numbered as I have described. I would have thought that having the records number 1, 2, 3, 4 , 5 etc would be a pretty straight forward thing to achieve...

Hi, I have a query that sets up my table for using at various points, want I want to do is have an Item number field created by the query. Essentially I just want it to number the records from 1 through N, like an AutoNumber field in a table but i want it to always start at 1 for whatever is...

Thanks all for you help, the application works perfectly.

I put the code in the double click event on the Product_ID, works perfectly! I have some subforms on the bottom of the form which I cant seem to have update after doing the double click, mainly Order_PReq subform, i have added the bleow code after the "CurrentDb.Execute strSql, dbSeeChanges" of...

never mind my previous ques....completely missed your coding!....it has been a long day. I will try that now.

Thanks for the response.. Yes Product_ID is indeed a number, how do I do an insert query using the Product_ID from the record i am currently on in the table list shown on the form?

Hi, I have a form which carries out a filter / search on a table and displays it in a subform using via query. The search essentially uses criteria selected on the form to filter down the data. What I want to do is in the subform showing the filtered results, double click the record selector...

It’s the same pc and the same piece of code. I appreciate some aspects of the code is not needed but I’m not concerned with that at present. I have pulled a copy off the servers onto a drive so had to reroute some code whilst I figure this automation part out. The code works perfectly well and...

thanks for the response June. It all works fine, opens Access, manipulates excel but errors on the email creation. Which I don't get as it all works fine if I run it manually from a command button...

Hi All, I have a VBA code which creates some excel sheets, saves them and then emails them to the required email address. This works perfectly well, however it requires the user to click on a command button. What I want it to do is to automatically run the code and send the email every day...

Hi Maj, Which bit of that code do I need to replace with The RS.New? Cheers

Not sure that helps me here. The sample number is the auto number and must be auto generated. The holding table is used due to the reasons given in my previous post. If I do t need to use it then great but I can’t have the main table utilised all the time by the registration as this is open...

Ok so we receive samples from client (around 15,000 per year) on receipt each sample is registered into the database. The main table has an auto number field which is the unique sample number (eg: 00001001, 00001002, 00001003 and so on). The main registration form is used to enter the sample...