Search results

I want to copy the entire window of the currently-displayed form to the clipboard as a picture. Then I can paste it into my Word document. When I press <Alt><Print Scrn> I get the entire Access application rather than just the form window that I want. Any suggestions? Thanks in advance.

Thanks. Thats just what I needed!

I have a table, called TableData with several records. The form to view this table is called FormData which is formatted to show only one record of TableData. Another table, TableConfig, has only one record and is used to shows my current configuration. One field, FieldDataCurrent, is the ID of...

I can't put a hyperlink field into a crosstab query. The Crosstab row is set to Row Heading. If I set the Total row to Group By, then I get nonsense. If I set the Total row to First then I get a text version of the address, with the character # at the beginning and end. Any ideas?

The sorting is only one task. I also want to do comparisons. Perhaps you nice folks can suggest an alternate solution. Here is the problem. Given a inventory of products, each defined by 3 parameters, each of which has a data type. Begin with the "lowest" table in the object hierarchy, the...

I want a column in the query to be used for sorting but it depends on the type of data. In preparing to use my tables, I used a simple conditional formula: sortField: IIf(IsNumeric("123"),CDbl("123"),"123") Given that the test condition discovered that the data is numeric, the result is the...

The recursive stuff shouldn't be a problem. There's a great example using a TreeView from Microsoft. But I still can't seem to get the form right. I'm sending you the sample file separately (our firewall prevents uploads to internet). Perhaps you could look at it and tell me what i'm doing...

1) I tried that but I couldn't figure out how to do the form (assemblies) and the subform (components per assembly). How do I go about setting it up? 2) If I understand your "two-level bill" then my applicatoin is deeper: every assembly can itself be a subassembly of something higher up in the...

hmmm... waiting for an answer gave me time to figure it out myself: it was the refresh. I removed it and everything is fine! Now the only question is how to get the delete button to delete all associated records.

You are right. But I don't want to do so much work at the table level. Instead I built a form for adding assemblies and added the following code to do the following: a) Open ITEMS and add a record. b) Paste that new record's ID to this form c) Close ITEMS and refresh the form so that ASSEMBLIES...

Background to question: Here are 4 Tables: 1) ITEMS IID (PK, autonum) 2) COMPONENTS CID (PK, number) CName 3) Assemblies AID (PK, number) AName 4) XREF CID AID ITEMS is the only place where the unique IDs are generated. (This is done to allow any new table (e.g. PDF_SPEC) to be joined to...