OK. I think I am understanding. I also found the following that the users said they preferred. However, I cannot easily break it apart.
select integer_value
from dual
where 1=2
model
dimension by ( 0 as key )
measures ( 0 as integer_value )
rules upsert ( integer_value[ for key from 1 to 10...
Is it possible:
Create a dual table with one field that starts at 1 and goes to 100 WITHOUT using unions or referencing another table that has 100+ records?
My use of the table is to populate a dropdown in another application.
Is it possible to default where an application displays? I have a user that has computer with a built-in video, and an additional video w 2 video ports. Ultimately, 3 video ports available. The applications will randomly open to monitors other than the Primary. We can display the screen ID...
I have 2 PDF files. The first one I saved as the foreground, the other I saved as the background. Is it possible to merge the 2 documents so that I have 1 file where the first file is the foreground and the second file is the background and, ... the first one is transparent enough to see the...
Is it possible to make the Page No and NoOfPages appear in a cell that is part of the header? For example, if I have 5 lines that repeat as the header with every page, how would I get the page numbering scheme to appear in a particular cell?
I am trying to update a record that is locked in Access. I can navigate to the record in question and change any field, but when I step out of the record it gives me an error and will not accept the changes. I have the recordset on a Novell network and am the only person accessing it. I have...
Whenever I am in a particular process and have feedback coming to a form and I step away to another application, the feedback no longer refreshes. How would I overcome this? The feedback is actually a variable that increments with each record and is displayed on the form.
I am having to import records from Access 2000, FoxPro 2.6 into a not-so conjested Access 2000 for reporting. Is there a some tips or tricks that I might not be aware of that would increase the importing process, such as CacheSize and the sort?
Say the example below is the contents of the combobox. Instead of choosing the Employee ID(Col1), say the list is extremely long and I know the name of the Employee(Col2). I don't want to change the TypeAhead for the EmployeeID since I ultimately want the EmployeeID returned; but what I would...
Let me explain my scenario first before I ask the question. I have a combobox that has 2 columns sorted by the second ASC and first DESC. The first is numeric and the return column while the second is additional text. The TypeAhead feature works just as I would expect it to. My question...
Is it possible to pass parameter values to a query that is not bound to a form or report? For instances, say I have a query and it has [Start Date] and [End Date]; can I DoCmd.OpenQuery "qrySomething", ...([Start Date] = a starting date) and ([End Date] = a ending date).
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.