Search results

I have a summary form with a datasheet subform. What I want is one of the columns in the datasheet to have a button or a link to open that record in the full detail form (my "Smart Sheet Form"). I'd also like to close the summary form when the detail form opens if possible.

Ah, of course, at least I was close! Works like a charm, thanks. And your point is well taken, I have chnaged the field name to TimeTaken1. This is already a subform so I'd rather do it this way than a sub-sub-form. Thanks for your help.

I have a form (viewed in datasheet view) with a column for the machine used and one for the time taken. I know how to make a total box in the footer: =Sum([Time]) that adds up all the times but what i need is 6 boxes which add up the times for each machine something like...

Its OK I got it, finally! I think the problem was that I had lots of Fields called ID in different tables that had nothing to do with each other. Access kept deciding to link my Orders and Products by ID instead of Product Number as I told it. So I renamed the ID fields to more specific names...

Yep here you go. I have the table working correctly with the plusses on the LHS But Im having trouble getting the relationships and Query to work. So I need a query to tell me all the processes needed to complete every product that is on order. Ideally it would also multiply the time and...

OK I thought I had a handle on it, but apparently not. I realised there is nothing that is really needed in the original PROCESS table, and I would rather use the PRODUCT LIST table instead. But I cant seem to get the relationships right. Can you talk me through how you did it? PS- Love the...

Yea I found it. You just put this code in a new module: Option Compare Database '*************************** Code Start ************************ 'This code was originally written by Terry Kreft. 'It is not to be altered or distributed, 'except as part of an application. 'You are free to use...

That is brilliant, thank you. I had to make one query of orders then a jobs query based on that plus the steps. I will try to keep my tables normalised in the future! :)

Is it possible to have the Switchboard maximised but have all other forms open not maximised? OR can you detect the screen size available and set the switchboard to that size (ie ReSize not Maximise). I have it set big but some people have different resolution monitors.

My tables are in the attached database. Each product requires a different number of steps to create. So I want to make a list of all the steps (or "jobs" or "processes") required for each product on the orders list. For example: Product1 needs to be cut then welded then painted. Product2...

Yea you're probably right, but how can it give me mutiple rows for each product it finds? (one row for each process of making that product.) I have restated the question in the Querys section here: http://www.access-programmers.co.uk/forums/showthread.php?p=635109#post635109

I have a table of products and a table of orders Each product requires multiple processes to complete Can I make a query that will lookup the products in the orders table and show a list of all the processes that need to be done to complete all the products on order? The bit I dont get is how...

I wonder if anyone can help me with this as I am new to ACCESS and VBA. I need to populate my Jobs table using data from 2 other tables...I think it needs to be done in VBA but I am open to suggestions... This is my idea of the subroutine structure: repeat loop for each record in the ORDERS...

Maybe Im just talking to myself, but someone might find this in a search and find it useful... I have now finished my schedule / calendar Its weekly now, I couldnt fit 31 days on the form, and weekly is actually better for my uses anyway.

I do have it on Vertical Only. But when there is no data in the table there is no vertical scrollbar. Which of course makes sennse normally, it just looks ugly.

I have a form with a series of subforms in it. The subforms contain a list of records and have a vertical scrollbar Sometimes some of the subforms are empty, so no scrollbar is visable, just an ugly space. Is it possible to have the vertical scrollbar of a form or subform "always on" or...

I need to find out the date of say: Monday of Week 1 in 2007 I get the weeknumbers using DatePart("ww",[Del Date])

I think I have cracked it. Here is the starting point in case anyone else is interested.. (it only shows the first 3 days of each month so far)

Does anyone know how I could go about making something like this: http://www.aislebyaisle.com/access/calendartool.htm I dont need all the options at the top, just a month & year selector. Lets say my data is in a table DATA1 with the following fields: DATE1 ORDERNUM PRODUCT So I pick a month...

I'm having the same problem.I have 5.3 in the list but no 5.5. Is there some update or service pack I can download to add 5.5?