For some reason it does not like the percent sign:
oSQL = "SELECT*"
FROM TableInfo
WHERE Caption Like "' & strTarget & "%'"
oResults = oSQL.Execute
Any ideas...
Hi,
I have a form that loads from a menu option. The form has two subforms. All the specs are divided in groups within the forms and subforms. The forms depend on 3 queries that have all the tables correctly gathered. So, every title has a little print button next to it if the user wants to only...
Hello again,
I created a form from a query which before loading all the controls asks for the Item ID (parameter). This form has two subforms that depend on another two queries; since I want them to show the info for the same item, all three ask for the Item ID, which can be kind of annnoying...
Hello everyone,
I would like to create a "search engine", through a macros if possible, so that the user can find the one thing among the hundreds of specs available to them in a form/subforms assembly.
My form has two subforms built into it, hence it can be really time consuming to find the...
Hello again,
I have a report that is 3 pages long. When users check out a form and click the print button, the report is printed (I have a macro doing the work on the background). I was wondering if there is a way that the macro would ask the user which pages of the three he or she wants to...
Hey there!
I made a form where I added two command buttons. The user is supposed to be able to click the command button and have the report Print. I was right-clicking on the command button and I was trying to write the code, but I am very new at this, so I think I messed it up and made it...
I am trying to create a folder inside another newly created folder.
First, I create a folder named 'newvolt' using the _mkdir function:
_mkdir(newvolt);
Next, I try to create a subfolder named 'SG019810002-500' inside the folder 'newvolt' using the _mkdir function once again...
I'm having difficulty opening a destination file using an array called "mystring" in the line
instream4.open(mystring);
First, I open an instream file that contains the following:
C078D2A2.DAT
C078D9E4.DAT
I take the first 12 characters from the file and insert them into an array called...
I'm having difficulty opening a destination file using an array called "mystring" in the line
instream4.open(mystring);
First, I open an instream file that contains the following:
C078D2A2.DAT
C078D9E4.DAT
I take the first 12 characters from the file and insert them into an array called...
I am trying to put characters into an array.
I placed the following in a file called "ultranew.DAT", character by character (with a white space at the end):
C078C75D.DAT
I open the file "ultranew.DAT" and a destination file called "ultranew2.DAT" with the following code...
I'm trying to write a program that opens files from a disk without already knowing the filenames or having the user input the filenames. I do not know how to open files without knowing the exact filename and using syntax such as:
in_stream.open("C078C75D.DAT")...
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.