Search results

How do you have your column headings set up now? Is it the months of the year, or what? If there is a set total number of column headings, and it's not large, you can put them all in the query as column headings, and then have them all in the report. You could also do a dynamic crosstab report...

If you want the report to have columns, you will either have to make a dynamic crosstab report (do a search on this site for this) or define column headings in your crosstab query. Without doing this, Access does not have any info to suggest columns for your report. If you are going to have a...

RuralGuy and mbrost, I wanted to thank you guys for this thread, as it helped me solve my own subform issue. The Search function is VERY handy! I have used Access for a few years as a workout log, but my original setup was NOT normalized at all. I've been going over a lot of my older stuff and...

I don't know about using a mouse to act as a digital pen, having never looked into it. With the Topaz pad, yes, you set it up on your Access app, with a "sign in" form(s), and when the person writes on the pad, it shows up on the form, and (if your coding is alright) the signature is saved in...

I believe the sample Access stuff is in the "Downloads" section. 2002 will`likely work for 2003 version, just make sure any applicable references are checked off in the Modules section of your app. I don't know if this will work with other brands, as I only have experience with the Topaz stuff...

Hi. There was a similar question on digital signature a short time back. I'm not sure if the poster was wanting what you want, but I gave an answer for your situation. Search here on the word "Topaz", and/or Google "Topaz", and you will find some information. We use 2 Topaz signature pads, for...

Lims Hey Spectrolab! A fellow PANalytical user, cool! I am based in the US, in the state of Kentucky, and I run a lab for an alloy manufacturer. We've been PANalytical customers since the 1960's, I believe, though I heard they had an ARL in here in the mid 1960's as well. I still have a couple...

Spectrolab, if you do a search on importing text files, and focus on my username, you'll find a post that deals with writing some vba to import spectrometer data from a WD-XRF spectrometer's text file reporting setup. In fact, Wayne Ryan was a huge help with this (thanks again, Wayne :) ). We...

Shadow, Thank you!!!! I'm not good with SQL, and did not know you could limit the recordset in the query like that. I've been going all over Perdition trying to limit the count of records returned in a query for a report, to keep it from being cumbersome, and this did what I needed. Thanks again!

I'm wondering if my tables for the individual sieves and the stacks of sieve combinations is the culprit. Anyone else have input on this one? Thank you.

That's a bit large. I'm betting your tables, queries, forms, reports, and code are all in one MDB file. A good practice, in case you are new to Access, is to keep the actual data tables in a separate MDB, called the "Back end", and the forms, queries, reports, and code in another MDB, usually...

In your new database, or another blank database, right click out in the middle of the database screen, and choose the "Import" selection. A browse window comes up for you to select a database that you want to import objects(like the form with the code you need to see) from. Follow the steps that...

What causes the letter to be generated? If it's a button that the user clicks, look at the underlying code of the button to see if the file location is referenced there. Possibly the file location is stored in one of the tables as well?

In other words, I've not normalized the table structure enough? tblScreenTestWorksheet was originally Screen Test Worksheet in the application. For tblScreenTestWorksheet, I removed the 8 fields that contained the raw data, and moved them to tblScreenTestWorksheetRawData. Should I break...

Hi folks. I'm going over a laboratory application that I started a few years ago, trying to do a better job with some of the table structure that I set up, and improve the application. Right now, I'm working on the very first thing I did when I started building this application. This part has...

How about having the 2nd form open, in hidden mode, when you open the other form? Upon closing your other form, programatically close the 2nd, hidden form.

Thanks Sergeant, for posting that. I put in more searches, and found some great posts on this topic. GHudson had made a post about the use of Environ("UserName") for doing this also, and it looks to work very well. This pricked my interest because of the instrument data project I've been...

Sergeant, okay, I think I see. Your backend has their network workstation username in a table, and the conditional compares the network log-in username to what's stored in your BE.

Out of curiosity, following up with what Sarge is proposing, would it be possible to screen users for different FE,s by having Access check the username that has been logged into the network from a particular workstation?

Taurus5, a simple solution might be to put a "New Record" command button on the form. The Access Wizard will make one for you. You can hide it if you like. Then, use the code given above to make it the next tab item. Maybe even easier, put in the Lost Focus portion of the last text box you...