Search results

Change the join in your query from an Inner join to an outer join. Look here for an understanding of outer joins. http://office.microsoft.com/en-us/access-help/creating-an-outer-join-query-in-access-HA001034555.aspx

Welcome. What is so confusing? Questions asked. People here answer them. Pretty simple.

Why do you need to have a running sum in a table. This is probably not a good idea. It is also a spreadsheet mindset. You can do running sums in queries if the data needs to be presented. Here is a link on how to do running sums in queries. you will have to read through most of the threads...

I misunderstood your requirements. I assumed that you had data in column C and was updating data in Columns D and E only. Never assumed that you were adding new data in column C. Will re-look at tweaking the code. Will you be changing the data in columns D and E once entered or only entering...

Try this: Private Sub Assembly_Click() Dim i as Integer Dim LastRow as Integer LastRow = Range("C" & Rows.Count).End(xlup).Row For i = 3 to LastRow cells(i,3).FormulaR1C1 = "=" & cells(i,3) & "-" & cells(i,5) Next End Sub Private Sub Received_Click() Dim i as Integer Dim LastRow as Integer...

This should help http://www.datapigtechnologies.com/flashfiles/searchform.html

Looking at your table layout, it appears that you have a normalization issue. Once you have your table normalized, your queries will become easier to manage and the results you are looking for easier to create. Your current layout resembles more of a spreadsheet mindset versus a RDBMS. They...

I have just tested Environ("username") in the immediate window of my application and it seems to work fine. Are you sure this is the issue and not something else in you code? Could you post the code you were using in AC 2003 that is not working in AC 2007 for review?

John; Since it appears that you are not making much headway here, perhaps it is time for you to upload your db for analyzation and specific instruction on how to resolve your issue. Sanitize it for confidential materials. Run a compact and repair before uploading. Also, it is not necessary to...

wojnicztrust I have read all the threads here. I have viewed your sample data bases. I don't understand the business of your databases. Would you please explain as clearly and simply as possible what the business process is. What you hope to achieve. This will help us to help you as it is...

Did you look at the link that Paul provided to Allen Browne's site on calculated fields. I do not use macros in Access. I have always used VBA, so I cannot help you further.

It is generally not a good idea to store calculations in your table. You can do this in your form, in queries and in reports. If you need to present the information to a third party, you can run a query or report with the calculation. Tables are meant to store raw data.

I played around with that and could not figure it out. Maybe try putting the minutes portion of the expression inside a Format function? Perhaps you should start a new thread on that issue and someone else will have the answer. It has stumped me. Glad to have been of help. I enjoyed...

Take a look at the attached and advise if this meets your requirements. EDIT: After posting this response, I happened to hit upon this thread in an unrelated search that I thought might be of interest also. http://www.access-programmers.co.uk/forums/showthread.php?t=147496

Have to run out for a couple of hours, but had a thought. First look at this. http://www.techonthenet.com/access/functions/date/datediff.php I'm thinking that you may have to develop an expression that uses DateDiff and calculates minutes. Then another expression to convert to hours with...

Is the time out the time at the end of the day? If this is the case then in a new field in a query type the following: Total Hours: [Yourtablename].[Time Out]- [yourtablename].[Time In] -([YourTableName].[Lunch Out]-[Yourtablename].[Lunch In]) use the query as your record source for your report.

What is the format in the underlying table?

How are you populating the tables. If in a form, you will need to set up a parent child relationship. Once this is established then it will self populate. This should help you get started http://www.datapigtechnologies.com/flashfiles/subforms1.html

Here is a good starting point -- http://allenbrowne.com/ser-27.html Also this is good site for getting started. http://www.datapigtechnologies.com/AccessMain.htm It will help with setting up the combo boxes and lookups in your form. Also it looks like you will have a subform that has the...

Are you looking to sum the two differences, ie 8 to noon, and 1 to 5. The net being 8. Is this the type of calculation you are looking to do? Next question: Where? In a query? In a form? In a report?