Search results

I'm having trouble with a query criteria causing SUM fields to not add up as I wish. Basically, I need to run criteria on a field, but I don't show that field in the resulting data table. I want it to ignore that field (NOTES) when summing the prices. Test Table: NAME CATEGORY PRICE...

I ended up with a form laid out sequentially into the following steps: The first item is a combo box that lets you choose the lab format (so far, I've only got this set up for one lab). This is next to a button that launches the corresponding script in R. The R script prompts the user for an...

Hey! I think I've got something going here that is a little faster: 1) Flatten data in R, import to Access (hoping to eventually automate this, but so far, manually) - looks like flattened file above 2) SQL query adds two columns to the imported table: LinkedNutrient and LinkedFood 3) A form...

Thanks everyone for the speedy and detailed advice! The_Doc_Man - thank you very much for such a detailed procedure. I think that is a direction I will head, with some modifications that have struck me in the meantime. Here is my current thoughts to changing the procedure using your...

Thanks - but this still involves me manually coding all the original data files in Excel. I guess I was hoping I could use Access to recode the data somehow. Right now the first two steps on my process can take over an hour per report (there are hundreds of items on these reports), and I get...

I have a database containing nutrient information for a variety of foods. We regularly get nutrient reports from various analytical laboratories. The reports are in excel, and they name both the foods and nutrients with a variety of non-standardized names. The data tends to come to us in...

I would like to import (using an append query) data in the following format: Sample Name Carbon Nitrogen Oxygen Hydrogen Sample 123 10 20 30 40 Sample 234 15 54 25 60 to a table in my database with the following columns: RecordID (autonumber primary key) SampleID (foreign key to table...

In that case, no global relationships were likely set up. You'll likely find the relationships within each query as you open them, and they may differ from query to query. It is not essential to access (but often helpful) to specify the relationships globally, so the developer may have chosen...

On your form, create a new combo box where you will enter the EAN you are searching for. Access will give you some options for the behavior for the combo box. Choose the "Find a record on my form..." option. Next, create a query that includes the EAN and the other info you want to know...

For what it is worth, I eventually implemented the solution here. I'm sure the more security-conscious of you are horrified, but it works for us so far with no problems.

Thanks Ken and plog. I think I will go with reorganizing my table structure. There are a couple of other issues that would be improved that way as well. Usually I'm pretty good about that, but this one seemed so straightforward with just a few criteria for each document that I opted for the...

I have a table that holds the dates of various approvals for documents. Approval Dates DocumentID ApproverA_DateApproved ApproverB_DateApproved ApproverC_DateApproved LastUpdated In a query, I'd like there to be a column with the date of the most recent approval (max date) for each document...

CJ_London - thanks for that link. I think I'll keep looking for other options in the hopes of not having to hacking registry files, though (which I'm sure our IT dept. would seriously frown on), but I'll keep that in mind. Our IT dept. doesn't mind changing a setting, they just aren't sure...

My IT department applied an update to our Office 2010 installations. Previously, when a user opened a database for the first time, or from a new location, they would get a “friendly” yellow button warning them that this was not a trusted document, and giving them the option to trust it...

Thanks! Okay, I'll just sanitize quotes, then. I'm not worried about sql injection - this is a local db for use by just a few people.

Any that would break an SQL statement called from within VBA. I know single and double quotes are problematic, and I'm pretty sure parentheses, brackets, # and * would cause problems as well. If there is a definitive list, that would help too. Thanks :)

Is there a function that will sanitize user-entered text and remove problematic characters for SQL? Or do I have to replace() each one individually?

I'd set up the tables differently - one customer can have multiple addresses, each with a start and end date. The one without an end date is current (or you could have a separate column for "Active"). You can use the end dates to order them. This will let you keep a more complete history and...

Thanks for the suggestions! That software looks absolutely perfect for what we want, and has way more bells and whistles than I would be able to program into the DB. It will take us months to get it approved and vetted, though, so in the meantime I guess I'll be hardcoding some logon data! CB

We have a database that is split. Every user has their own front end (installed via a .bat file so that the users always have a local copy of the most recent version), linked to a shared back end on a server. This seems stable and functional for us so far. However, because our users are...