Recent content by Eureka99

Hi, I'm trying to count the instances of a vendor ID appearing within my inspection log table within the last 12 months. The base DCount works, but I'm having issues adding on the date criteria on the end. I've cobbled this together from various peoples reposonses I found on google. Can...

Just the me.Requery its sole job is just to try and refresh.

Yes, nothing seems to happen.

Ok some files attached: Can you post a picture of your form? - Stats Form.png Show where you "try to update the date". - Date textbox.png Show the query code/sql. - Stats Calcs.png How does the "new date" get associated with the query(s)? - Date association.png

I'm not sure if this is best in the Forms, queries or VBA sections. Also i might be doing this completely wrong, please let me know. I have a form that is showing some stats about factory production levels. when the factory finish building a product they will log the test within the database...

I put ' ' around it just as thats what the guy who taught me SQL taught me to do. It works without them. Strangely in the query builder I seem to have fixed it. I removed by "Distinct" command and selected unique records from the options. It gave me this code that now seems to be working. I...

No It doesnt. I've tried it two more ways. On the unsplit database I've used: SELECT VMMTNO FROM EIT_GB_MVXCDTA_MWOMAT WHERE [VMMFNO]=1744373 ORDER BY VMMSEQ; which doesnt work and gets me the same list of 14 x 1 component. I've checked it on MSSMS which gives me the full list SELECT...

Hi Chaps, I have built a database that is using the sql code below to dump a list of components from a SQL data warehouse into the access database. Whilst the access file is in one piece this works fine. When I split the database into front and back end, it then falls over. If a product has...

Many Thanks Josef!! And i found your bug worked perfectly and exactly what I was looking for. CriteriaString = "MONo=" & MO1 & " And " & "SeqNo=" & Comp1

I can do I guess, But i was hoping to be able to auto fill a couple of lines at a time with extra data. So for example I will have two linked tables MO Head and component. One such line I wanted to auto insert was the ID field from the MOHead table. The MO Head is being filled using barcode...

Hi All, I'm doing a database whereby I'm taking some Manufacturing order details and adding them so we can look quality pass / fail rates and details. One MO might have anything from 1 to 20 components. I have linked tour data warehouse to the access file instead of calling it in through SQL...

Many Thanks

Hi All, I've been tasked with reporting on the Holiday / Sickness within my company. I have a quick question. I have a calendar with all dates for x years. The sickness data I have is just a start and end date. I need to break this down into how many days per month. With a query, how would...

Worked perfectly. MRoom is a field on the form. For some reason it worked better without the Me.MRoom. It populates the correct part on the meeting request.

Hi All, I have some code for creating a meeting within MS outlook that appropriated (I don't know much about creating meetings using VBA). The issue is it seems to cycle through the code and it gives me a Runtime 440 error saying parts are not supported. The two that it has flagged so far...