Search results for query: *

Hi, I'm just trying to make sure no one alters the information in my database when using it. I have a popup form, and that's all that I want the user to see and use. I want the main menu area (that includes the tables, queries, forms, reports, macros and module tabs) to be hidden. I also have a...

Thanks alot mac I'll try it out.

Hi I have a couple of questions that sum up to one problem... I have a form and a table. The form has 10 fields on it, I've been trying to get it to, once the first field is filled in, auto-fill in the other 9 based on the corresponding field data for the record (assuming that the first field...

Mac Thanks for the reply. See that's exactly what I WANT to do. I just haven't been able to do it successfully in Access. How should I go about it?

Hi, I have one main table with 150 entries. I have another table with 6 entries. This second table is just one field of OLE objects (metafile images). Each entry in my main table is associated with 1 of 6 images (the OLE images stored in the second table). I want to have a field in my main...

I figured out a way to save an Access report as a .pdf file Here's how: Get the Adobe Acrobat Distiller (might be able to get it free off their site) This will allow you to print to a "printer" called Distiller Assistant (it's more like "scanned" to it). In order to do...

Hello forum, I have a report that has a page for each of 150 cables. On each page, there's a detail, subreported section and a picture. The pictures path on the harddrive is dependent on a field gathered from the main report's source query. Now, before I added the picture updating capabilities...

Geno, Thanks for the expedient delivery! I looked at the snaking columns section of Access Help. It pretty much led me to the section on making extra columns and changing column size. I had played around with that before, to no avail, but I figured I'd try again. What caught my eye was the...

Hi, I just want to have a report display 10 rows per column in a report, and then have any left over records be tossed to an adjacent column. For example: If I had only 6 records in a source, my report would look like this Column 1 A B C D E F But if i had 26 records in a source, my report...

Hey Lozere, sorry about that. thanks again for your reply. it's the same issue, just explained more clearly. I probably shouldn't have made a new thread. Anyway, I tried that before. Now, I'm generally new at this, especially when it comes to coding and the Event tab. I opened the properties of...

Hi everyone, I'm a standstill on this database at work. I can't go any further until I find out a way to do this. I have a query thats finds one record (row) from a main table. The row is then displayed in a report. In this report I have a subreport. I want the subreport to have its record...

Hi everyone, I'm a standstill on this database at work. I can't go any further until I find out a way to do this. I have a query thats finds one record (row) from a main table. The row is then displayed in a report. In this report I have a subreport. I want the subreport to have its record...

Hi everyone, I'm a standstill on this database at work. I can't go any further until I find out a way to do this. I have a query thats finds one record (row) from a main table. The row is then displayed in a report. In this report I have a subreport. I want the subreport to have its record...

Hi, This may not apply directly to this forum, but I didn't get a solution in the other forum and you guys and gals are usually right on. I have a report that has a subreport in it. The report displays a picture and one row of data. The subreport in the report will display information from a...

Hi, I just tried it. It comes up with a syntax error for the FROM statement. Then I tried to just put [Forms]![Test].[VARIABLE] and it actually looks for a table called "[Forms]![Test].[VARIABLE]" any suggestions?

Hi, I have a report that has a subreport in it. The report displays a picture and one row of data. The subreport in the report will display information from a table depending on the content of one of the cells in the row of data displayed. Is there any way to have the record source of the...

Hello. My second posting of the day is in regards to exlcuding certain entries by means of a query. After searching this forum, I came across the <> operator. This allowed me to run a query that would exlude all entries containing a inputted word. The only problem is that it will only return...

thanks alot guys!

Hey Maq, thanks again. OK, I'm realizing how much there is to learn about this program. You're right about how my form works, I had assigned a macro to run the query. I've never used the Event settings. I know that you can find On_Click by accessing the properties of the macro button assigned...

Thanks for the expedient reply Maq. I can follow your code, but I guess I don't know where to put it. I'm really a novice at SQL, I just really only know how to view it and do minor alterations to already-existing code. If there's any way you you could break down the process on a beginner...