Search results for query: *

If I make only one selection from the listbox the SQL works perfectly. If I make multiple selections, it pulls everything (I.E. As if you didn't put in any criteria for strWhere). Any help would be really appreciated. Private Sub CmdExport_Click() On Error GoTo Err_CmdExport_Click Dim...

StrSql = "INSERT INTO ForfTest ( CASE_SEQ_ID, PROCESSED_DATE, TRNMSTR_SEQ_ID, AMOUNT ) " & _ "SELECT PUBLIC_PPAK_ACCT_ACTIVITIES.CASE_SEQ_ID, PUBLIC_PPAK_ACCT_ACTIVITIES.PROCESSED_DATE, PUBLIC_PPAK_ACCT_ACTIVITIES.TRNMSTR_SEQ_ID, PUBLIC_PPAK_ACCT_ACTIVITIES.DOLLAR_AMT AS Amount " & _...

Hello, I have been trying to get this code to work for me and I just can't seem to get it to work right. It appears that the code is just skipping over my first "If" clause and going straight to the sql. Any help would be greatly appreciated. Private Sub Command10_Click() Dim strSQL As...

Hello everyone, I am trying to do a running total in my report. I have no problem with the running sum in the detail section of the report. The problem that I am running into is that I want to have a starting point. I have a textbox in the header that has a value in it that is pulled from...

Hello All, I have code that I use to import a group of text files into my database. What I am coming across is that I forget what the last file was that I imported since they are moved off to a different server after I have copied them. I would like to set a textbox or label on my main form...

Hello, I am working on an accounting database. There are many different trans codes that I work with. There are a few that cross between the financial ledgers that I am trying to work with. Due to them crossing the ledgers, depending on which account I am trying to work with they may need to...

Hello everyone, I am trying to get some code to work and am not having much luck. I keep getting a Jet error 3011 saying that it can't find the file "ppab0379.4837.txt". I know that the file exists just as it is above. Any help would be appreciated. [Code] Private Sub bImportFiles_Click()...

Hello all. I am trying to validate my form before I update the table. I am getting hung up on the combo boxes. Can someone with a sharper mind than myself please take a look at this and see what is wrong and how to fix it. Private Sub cmdSubmit_Click() Dim ctl As Control, xCtl Dim...

Hello all, I have been using the following code to format my reports: Const vbLightGrey = 14540253 If Me.CurrentRecord Mod 2 = 0 Then Me.Section(acDetail).BackColor = vbWhite Else Me.Section(acDetail).BackColor = vbLightGrey End If It works great. I now have...

Ok... This is the code that I have so far. SELECT borrower FROM New_main_info,Boarders WHERE Boarder=Employee AND Unumber=Environ("username") UNION SELECT borrower FROM New_main_info,Boarders WHERE prestacker=Employee AND Unumber=Environ("UserName") UNION SELECT borrower FROM...

Ok... I would like to get a query of 3 different fields (Prestacker, Postacker, boarder) from the current users login (environ("username")) I have been playing with it and don't understand relationships and sql well enough to do this. All of the fields are text fields. Table: Boarders...

I need to get a count of files that were received per day, and then from that I then need to display the max number of files and the min number of files received. This will need to be in a date range style sql statement. If anyone can help me out I would appreciate it. PROXI Thanks, PROXI

I am trying to take a range of data (about 1200 records) that is put into a query. the query just has 1 field in it (Time). I want to have a line graph show the number of instances in 2 hr groupings. Right now this is the statement that is used in the rowsource...

Ok... My manager has just asked me to make a report for her that has too many fields to fit into a query. I need to generate a report from this query to give to her. Is there a way that I can make 2 queries and then merge the 2 onto a report. If so, Is there a way that I can do this using...

This is the code that I have now. It just hides a button from anyone that is not on the admin list. Right now I am defining it in the code... But I know that there must be a new way to do it. Any help is appreciated. Private Sub Mainhide() Dim strResponse As String Dim admin1 As String Dim...

I know that this is really simple. And I know that I have seen it on here before. But I can't find it. Can someone help a silly fool out with this. The 2 fields that I have are Loan type and p/r. I want to have a report show in 1 text box ; loan type & "" & p/r How do I do it. Thanks...

Ok. I have a FE/BE Database. It is in a networked office with about 20 people that use the database. About 3-10 times per day the backend corrupts itsself and I have to repair it. It builds a table when it corrupts called "MSysCompactError" and has a list of errors. The 2 error numbers that...

I have 2 tables, Collateral_shipped and New_main_info. I have 3000 records in the new_main_info table and about 500 in the collateral. I want to merge the 2 tables together. I have information in the colateral table that would fill in the blanks of the new_main_info. Right now it just...

This is the code that I have. I have 2 problems. 1) Is there a better way of doing this than this drawn out version. 2) Since putting this code in, now the shippedLW field is overwritten with 12/12/1899. Does anyone know what is going on and how to fix this? If Form_Main.YNDeleted = -1...

I have 2 tables with pieces of information in them. Some of the records are the same, others are different. I want to take them and merge them together to fill in the gaps in the records. Is there a way to do this so that if the record is in the main table as well as the 2nd table, that it...