Search results

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...

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...

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...

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...

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...

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...

I have a table with calculated fields. I have just imported a load of data into this table. Is there a way to force the table to calculate all the records calculated fields?

Hi Guys, I have a query that is using a SQL query. I want to use a filter to filter this by user ID. I have the below query, but I keep getting a Runtime 3061 error. The filter returns an integer value and the tbl_meeting.UserID is a number field. Can someone advise? If Me.cbofilter =...

Hi Guys, I'm trying to add a button that will add a meeting to MS Outlook. Most of the code I have been able to find / scratch together is working. But i'm having issues with the "TO" command as this wasnt in any code I could find. Any ideas? MRoom = DLookup("MeetingRoomEmail"...

Hi Guys, I need help with a DLookup I'm trying to use a dlookup to assign a value based on a date so I can use this in a query later as a condition on whether or not its greater. For example I have a table filled with Dates and values - So I've called this Tbl_Dex and it has 3 fields: ID...

I have a customer that wants to export a single record to excel when a record is complete. This is to do with Machine maintenance and keeping a record of the logged faults with any documents for auditing purposes. I've tried the below code but it still exports the whole table: Folder =...

Hi All, Someone has nicely managed to kill all the VBA in an old database so I have the nice job of putting it all back in. I need to use a where statement on a DoCmd.Openform, but I cant seem to get it right. I know some of the field names are not great but at this stage it'd take more time...