Search:
Type: Posts; User: Giftx
Search:
Search took 0.05 seconds.
-
Gentlemen,
I am gradually inching closer to my goals, thanks to all your expertise.
In my Form_Load module, both my controls(listbox and combo) loaded okay with the data from my tables.
...
-
Si,
my program ran okay and populated both the listbox and combobox.
However, regarding the formating of the string values that will be selected from the controls, how does this code that Hack...
-
Yes, Si.
I modelled after reading thru the article you recommended.
Below is the code I wrote based on the example from the article. However, when I ran it, I got error: Too few parameters....
-
Good morning gentlemen.
Hack, in response to your question, NO. My objective is for the user to select either a single value '00' (unioncode) or multiple values '00','01','32' (unioncode).
...
-
LaVolpe,
for the sake of user-friendliness as you pointed out,
can you give me a taste of how to accomplish this if I have to load values from the database into the listbox or combobox, then how I...
-
Si,
please take a look at my inputBox syntax. Maybe my problem is here. Something looks funky within the codes.
Unioncode = InputBox("Please Enter Union Codes for this report. Enter each...
-
Si,
I made the changes to both variables as you said how I have: Syntax error in String in query expression.
Note that I am supplying the values thru an inputbox, but the Debug.Print is not...
-
Si,
So, how do I fix it? I changed this to add quotes to Checkstatus as you specified and I had the same error. This time it is not even picking up the variable name, rather Checkstatus has empty...
-
Si,
I noticed something when I did
Debug.Print strSQL
The Debug.Print output picked up user-supplied input: for Begindate and enddate but did not pick up user-supplied input for Unioncode and...
-
Si,
so how do I properly enclose "CheckStatus" is quotes within the sql?
Thanks.
Giftx.
-
Hi Si,
Below is my complete module. If you look at my variable definitions, Unioncode, Begindate, enddate, the sql is picking up all other variables except "Checkstatus".
bPath =...
-
Please can someone show me a more efficient way of coding inputbox to accept multiple string values:
in my example below, the user may enter only a single string value, or may enter multiple...
-
Please can someone show me a more efficient way of coding inputbox to accept multiple string values:
in my example below, the user may enter only a single string value, or may enter multiple...
-
Good morning Si_the_geek,
in your comment about the variable "CheckStatus".
I am using this variable to accept user input instead of hard-coding it.
for example: I defined it as:
Dim...
-
Could someone help to show me what I'm doing wrong in this sql. I get the error when it hits the last line to execute the sql.
strSQL = "SELECT DISTINCT tblUnclaimed.PassNumber,...
-
Mr. RBull,
To be more specific, it is not picking up the new variable I added to the query
CheckStatus
It is saying Missing operator in query expression:
tblUnclaimed.status In ()
-
Hello Rhino,
thanks for your input. Your query executed okay, but when I added a new variable (CheckStatus) to the query, I got the same error. I must confess, I am not really good with placing...
-
Gentlemen,
they say more eyes are better than two :D . Can anyone see if they can see where my syntax error is in the code below:
Set rsin = Dbs.OpenRecordset("SELECT DISTINCT...
-
Thanks Si.
It worked.
Giftx.
-
Need some help and clarification.
I created an access query in design view. Now, I am trying to run the query using values from two linked tables.
I have selected the fields I need from both...
-
LaVolpe,
thank you for your geniune observation and input. Yes, I was using both DAO and ADO and it didn't like it. I removed the ADO and it worked.
Thanks again.
Giftx.
-
Gentlemen,
I have one annoying error and I have looked and looked and can't find the mismatch.
The code below gave the above error:
Set rsin = Dbs.OpenRecordset("SELECT...
-
can someone please give me a hand on how to populate comboboxes. Below is a sample of how I started, but I know it's grossly in correct.
I'm just trying to get the hang of C# for the first time....
-
Hi Hack,
I can use ADO/DAO to connect to database/tables/recordsets using vb/vba, but I haven't done that in C#.
Any guide/examples will do me a world of good.
Thanks.
Giftx.
-
Yes, I want to display values from a database in the ComboBox. Or I might want to add values to the combo just as you add items to a listbox.
Thanks.
Giftx
-
Hi everyone, I am so "green" in C# (C sharp) it's not even funny. This is the first time I am programming/creating a GUI apps using C#.
Question1:
I have two forms - form1 and form2. If I am in...
-
Thanks West.
I Kept tweaking until I got it right.
Below is the code I used:
Set NewSht = xlWbk.Sheets.Add(After:=xlWksht)
Thanks again.
Giftx.
-
Guys, Please I need you help on this. I currently have an active workbook that contains a single worksheet sheet(1). I want to add a another worksheet Sheet(2)next to the existing worksheet.
...
-
Gentlemen,
I need guidance on the above subject: I have this perfectly working vb module that takes input from an Access table/Query. The module then uses the query data to create Excel report. I am...
-
Rob, I got a new name for you - Rob-Ginie (for Genius).
Problem solved after I used vb6 component that you suggested.
Thanks and have a great weekend.
Giftx.
-
I am using vb6 standard edition.
-
-
Help please :(
I am trying t create executable (.exe) from my ".vbp" and I am getting an error display: "License Information for this component not found: You do not have an appropriate license...
-
Yes, it shows now. However, I guess since a user will only be running the executable (.exe), will they be able to still see the underlying db and tables?
-
Hi Rob.
Now I added
oApp.Visible = True and I was able to view the report. However, it also made the database and underlying tables visible. How can I avoid the db and table from being seen?
...
-
I am using Access 2000.
And what is sandbox mode :). If it is network issue, then I am screwed because I can't changed the db location.
-
Hi Rob.
Okay, "acViewPreview" is not doing a thing. When execution reaches that line of code, it waits for about 5 seconds and nothing happens and it executes the next line of code.
This is my...
-
Gentlemen,
I need a little help. I am opening an access report. But I want to be able to view the report in the screen, then print it if I want to.
I am using the codes below but, it only goes...
-
Thanks Hack.
Quite a lotta material to siff thru. In the process of this mini project, if I have further questions or guidance I'm sure you good guys will guide me thru.
Thanks again.
Giftx.
-
Mendhak,
Thanks for your tips.
Giftx.
|
Click Here to Expand Forum to Full Width
|