Search results

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