Microsoft Access / VBA Forum

Hi, I have a fully functional MS-Access database. May I build such an "exe" file from a MS-Access "mdb" file which one who has not MS-Access installed on his/her system can take advantage of the database? is it possible to have an standalone MS-Access application with no need to use the MS-Access environment itself ? regds, a. nasseh

Hi, In a query one can use the 'IN' operator but how can I do the same thing in a if statement?? as in the below which does not work. if MyRec!ClmTyp="p" and MyRec!PolSym in (I,K,O,P,Q,R,S,Z) then thanks bobh.

Is there a difference? A) WHERE (IsNull(qry100.Cat_ID)=True)) --or-- B) WHERE qry100.Cat_ID Is Null I'm thinking A is better because it is less ambiguous (?)

Hi, I have an access database with a table linked to an external text file. Occasionally the location of the database and the text file change (but are always in the same directory). Is there a way to have the location of the external text file be a relative, rather than absolute path (to be .\textfile.txt rather than C:\dir\textfile.txt)?...

I have a database with records consisting of phone numbers and date/time called. I can write a query to tell me how many times each number is has been called but also want to know how many once, twice etc. there are. ie 12 numbers called 1 time, 6 called 2 times, 17 called 3 times. Help!

My macro uses the Send Object (VBA Item.Send) function to email a spreadsheet to an Outlook contact list. I want the function to be completely automatic but Outlook displays a security warning message (...another program is attempting to automatically email...) that requires user intervention before the macro will finish execution. Can anyone...

Can Somebody plz tell me how to give the form ,a footer & header. I want to write in Heaer-REPORT FIRST But i m not getting how to type the text in Header & Footer, plz reply. Bydefault the user is able to resize the form,I also want that the user is not able to resize the form.

Hi, I try to run the below statement, it alway popup a box and prompt me to input the unit, what wrong with my statement. There is no sub form. DoCmd.RunSQL "Update tblvndprod set unit= " & Me.UnitMeasurement & " where productID=" & Me.ProductID

I searched here for an answer. I am entering records into a database, and it would save a lot of time if I could duplicate a record that is very similar to the new one I am about to enter, then make one or two changes to the new one. This is the problem I have with Access. Look at this answer! >Private Sub btnCopy_Click() >On Error GoTo...

Hi guys, probably a basic question but have been struggling for some time so thought i'd see if you could help. I have a main schedule table which contains the fields... Date; Machine; Arm/Head; Job Number; Stock Code; Operator; QtyPred; QtyAct My ideal form would be a continuous one (so I can easily search through a selection of dates eg....

I've tested many ways to accomplish this, but none of the code I've found works quite right. I am using the code written by Dev Ashish but it replicates some of the functionality I already have. And, if you change the path to the back end manually and launch the db, Dev's code throws an error. I think this request is fairly straightforward...

I am running/coding update queries in MS Acess VBA 2002 and each update query asks the user to click "Yes or No" to verify they want to update the table. I do not want this user interaction (since there are alot of queries) How can I set the Display Alerts to FALSE (like in Excel) so that this box does not pop up asking the user if they...

Hello - I am receiving the below error message when attempting to open a report. This database is used by approximately 20 users and only one user is having this problem (even I can't duplicate this error on my own PC). The command being used is DoCmd.OpenReport "rptSYS_ChangeInARDaily", acViewPreview OR DoCmd.OpenReport...

Trying to help buddyr in another question, I came across a little quirk I couldn't immediately sort out. I was building a string from the contents of a list box on a form, with the idea of filling a text box on a report and I wanted to insert CR between each item of the list using Chr(13), but that didn't work. I know that when entering text...

Is there an easy way to make all negative values positive in a particular table? I've been experimenting with this: Dim rst As DAO.Recordset Set rst = db.OpenRecordset("tblNegValues") Do If rst!Amount < 0 Then rst!Amount = rst!Amount - (rst!Amount * 2)

Hi Is there a way to recover deleted records from a table. A mass deletion has occurred and Access has been closed since it happened Louis

Hello all: I was wondering if anyone has tried (and got to work) calling a c#.net ..dll from VBA code? I have been working on this for about 2 weeks and am not getting any where. The_King

I have a query written in MS Access that has a few calculated fields. Is it possible to refer to that query in a form field. I'd like the form field to show the sum of one of the columns from the query I've written. I've tried to put the following in the form field's control source property but I'm getting an error. Query1 is the name of...

I need to be able to enter an elapsed time into a text field. This time then needs to be converted into seconds and stored in a field in some table. The user will enter a time (format is h:minutes:seconds) as such: 0:15:34 (0 hours, 15 minutes, 34 seconds -> 934 seconds total) or as another example:

I have a need to convert simple dates (i.e. 02/14/2005) to a number, do some math, and convert back to a date. (in a simple query). The math involves adding or substracting days, and days of the week . I've used the weekday() function to convert dates to numberic days of the week (1-7) I've used cdbl (date) to convert a date to a serial...

Hi all, Very new to this forum. Searched for relative postings but found none. Question: Does anyone know of any application that could convert/import scanned docs (PDFs) into access database (specified fields)? I constantly deal with paper works from clients like purchase orders, etc. and data entry into access is very time-consuming...

Hi all, I was wondering if any of you guys can help me out with this: I have two fields on a form: one field is Premium and the other is Brokerage. Whatever amount is in the Premium field is multiplied by 10% in the Brokerage field. If I change the amount in the Premium field, the Brokerage amount should change accordingly as well. I know...

I’m trying to use DoCmd.TransferText, (I use it successfully with a .txt export every day) to export a table into a CSV file. Right now every time I try – it says: Run-time error 3011 The MS Access db engine could not find the object ‘Inventory#scv’. Make sure the object exists and that you spell its name and the path name correctly. I...

Hi There, I'm a beginer in Access and VB. In my Database, I've got a form with a subform. the subform is a query from a table different than the table of the main form. those tables don't have a link yet. the main form is being use to create a new entry/ a new row in the table. What I want to do is use the primery key from the main form...

I'm trying to do something that I'm not exactly sure how to go about. I know about queries and how to do those, but my form isn't set up for that particular purpose. Like a webpage that has a "Check Username Available" type of function for some, that's exactly what I want to do. All my form consists of right now is a text box, txtUsername, and a...