Search results

Here is a tribal map of the Native American nations. http://www.emersonkent.com/images/indian_tribes.jpg

I'm confused by your clear button code. Why have the requery cmd before you clear the text boxes. Why run the query before clearing? And you probably need a requery in your actual search code. Anyway, look at this 10 minute video on a simple way to run a multi-search form on a query. It is...

You should look at doing an update query. Here's a refresher on the subject: http://www.databasedev.co.uk/update_query.html

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?