Search results

I have following code to post the variables to a online payment processing URL. Following code works great but the problem is Payment processing company want us to use two URLS - one for Credit card and other for Checks. Difference between tow URLS - besides URL a payment indicator...

Basic idea - pass one variable to test.asp page and have user add second variable (input form) on same page and pass that as new url to process on the same page (same page is the key). initial pass: http://localhost/test.asp?req=22 once "Submit" is clicked new post url is created like this...

How do i do this in VB? Here is my suitation, I need some guidence from VB pros. I have yes or no question if yes - then use text entered as static text in query else use a field from the table in the query. Y/N = 'Y' select 'Test01' as Exp1, a.id_num from tblTest a Y/N = 'n' select...

With the help form a this forum member i was able to get my Access VB working. http://www.access-programmers.co.uk/forums/showthread.php?t=109875 I would really like to convert this to MS SQL SP. What is best way to approach this? I can convert recordset to cursor, but how do i deal with...

I have code below to analyze existing network username to potential new user's usernames. If no match then user gets first initial and lastname if there is a match (conflict) then the user gets first two character from their firstname and lastname. Following code works except right after the...

Hello, I was wondering if you have one or have seen a routine to generate unique username from first, middle and last names. Here is my requirement - by default first initial and last name of a user is their username. But if the expected or default username is already taken then if the user have...

Hello, I am in need of your help creating a pie chart on my report. I have this small database that analyzes survey results. I have the report ready the way I wanted except the chart. I never worked on the chart before and my first attempt failed. In my attached database there is report called...

Hello need some advise. I have following on the table: ID Name CopiesPrint 1 Jim 10 23 Sam 2 56 John 3 Report Source Query: select id, name, copiesPrint from table1 I would like to print 10 copes of id 1 Jim and 2 copies of id 23 Sam and so on. I tried...

I need a help/pointer converting this cascading list boxes into treeview control. Please help. All the data I need to construct a treeview is already at category_info table, but unable to show it attrib_cde (parent), Stage (child of parent), and ID (child of Stage). Any help or a quick example...

I could not figure out this myself, please help. I have a monthview ActiveX with monthrows setup as 3 so it will display three months in row. However instead of showing lets say current month at the bottom of the row list, i would like it to show the current month in the middle. If the month is...

I am trying call below function with either of these call routine, but without sucess. Instead of variable FrmName if i use hard coded form name then everything works like it supposed to. I would like to call this funcation from custom toolbar or also from other forms as well. Any thought...

Hi All, I am having problem printing a label based upon newrecord. The report prints but has no information. I think it is because it is not save to the table yet since i have this event before update. Private Sub Form_BeforeUpdate(Cancel As Integer) Dim stDocName As String stDocName =...

I have a form called "form3" with tabbed form "Form1" with tabbed sub form objects within the "form1". All i am trying to do is, create a lookup form called "Form2" (click advanced option) and select the record in lookup form and return it to main form. See attach sample DB. If i open form1, it...

I need help wiAttath simple database query. Attached database has table with date, timeout, timein fields etc. I am trying to query a list of records where datediff <=0 and also TimeDiff < -15 and if datediff =0 (which is today) then timediff must be < -15. Actually, this is a resource...

I designed simple resource scheduling database. All the aspects of scheduling work, except duplicates (overlap) management. How do i prevent duplicate entry based upon TimeOUT and TimeIN values. Here is my table structure: Please advise this poor "STUCK" soul. Thanks in advance...

I have a table "tbl_attend", which looks like this. ListNum ID_num EventID Attend 1 23 1 Y 2 23 2 Y 3 23 3 Y 4 56 2 Y 5 56 3 Y 6 29 1 Y 7 56 1 Y I would like to query unique ID_num where eventid = 1 and 2 and 3 and Attend ='Y'. e.g: ID_Num 23 56 My ultimate goal is to find random five...

I have to run a lot of Sql scripts against .mde database. I am trying to create a custom form to run raw sql script either to update, select or even insert simple values into tables. I was wondering if any one one out there already have a sample database that does this. I have attached the...