Search results for query: *

Hello, I am creating a sub that executes a stored procedure with parameters. On the CreateParameter method, instead of defining the arguments for every parameter I want to append, I want to derive them from a recordset. But when I call the sub, I keep getting a "Mismatch" error and VBA...

The fact: Running an Access 2007 database front-end and SQL backend where tables are linked via DSNLESS ODBC. The problem: I have to generate a order line number in a query for each PO/order line in one query and derive the starting line number from another table. For example, I have a table...

Access has bunch of MSys* tables that were/are created when the DB is created. Is there anyway, I can move these to another backend database and link to them so that I can delete them on my front-end app? The reason why I'm asking is because I have a lot of objects and code on my front-end...

Hello, I've been scratching my head as to how I'm going to do this on a report and have been trying different ways but to no avail. So I decided to seek help from a site that never fails. Please bear with me as I try to explain it what I need the best way I can. Basically, I have a report...

Hi there, I've been trying to find out how to do this but I can't get the right results so I am resorting to tek-tips to help me out, as I've always had positive experience in these forums. Just to preface the problem, here's my table of data: REC_ID F_CD P_CD S_CD VERS_NO A 1 5...

Okay here's my task: I have a table consisting of 5 columns: FacilityID, , VendorPartNo, VendorCode, UnitOfMeasure, CommodityCode and Suffix Assuming that all records have values for all of the first five columns and the last column, Suffix is NULL. I want to create an update query that...

Ok, here's the problem: I have to 2 tables, one has a packslip # (Table A) and one as an invoice # (Table B). They are related by the PO number. I need to build a query where the return set contain the Item Code, Packslip # and Invoice # where both packslip # and invoice # are not null...

Hello everyone, I have not been in this site for quite some time now. It seems that I only come here when I need something and always leave with a smile on my face because everyone is just very helpful and very professional. I am somewhat still intimidated to post a reply even if I think I...

I have a SELECT query. When this query is run, it prompts for a PO Number. If PO is entered, it will filter the records for that PO. Now, what I want to accomplish is... How can I put a line number on each record that is associated with that PO? For example, it the filtered PO has 10...

Hey guys, it's me again. Question, if I had a form that has no record source (a table/query bound to it) and one of the controls (textbox) has a value I want to write to a table in the database, how do I do this? For example: A user open's a form (frmForm1), the form has a control called...

Hi guys, I have a startup form that prompts user to login, the values from this form are from a table (table of users). Private Sub cmdLogIn_Click() If LOGIN1 = 1 Then Do While flag = False If txtUserName.Value = User.Value And txtUserPass.Value = Password.Value Then...

Hi guys, please read my notes on the image I posted, it should provide enough info on what I'm trying to accomplish. So can this be done? If so, how? I was thinking more like a function in a module I can call when the form loads (the form that assigns the PO). But I do not know how to write...

Okay, I have a ftp script that runs and download datasets to my PC and save them as .txt files (ASCII). After the files are downloaded, the script tell MSAccess to open a DB and autoexec a Macro that imports the text files using import specifications. Now, my goal is to migrate this database...

Is there a way to prevent the user from deleting the tables by going into the database window and clicking on tables, and also prevent the user from opening the tables directly?

Hi guys, I'm trying to create a .mde file for my application (database) but I'm getting this error saying "Microsoft Access was unable to create an .mde database". What is causing this? And what can I do to resolve it? Help please.

Hey guys, does access provide a free barcode control (ActiveX)? Or does it provide anything that I can print barcode (native) labels from?

Hi guys... I have a form that has an unbound textbox control (txtPONumber) and the form also has command button that opens a report when clicked. What I want to accomplished is, when the command button is clicked rather than opening a report that contains all records, I want the report to...