Microsoft Access / VBA Forum

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...

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 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, 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

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.

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...

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!

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)?...

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, 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.

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

I have a report in Access that is grouped by customer with a page break after each customer so only their data is shown on the page. I would like to email the report to each customer with their individual data(page). I can get Access to email to each customer, but it emails the entire report and does not email only the specific customer. I...

Hi, This is driving me absolutley insane! Every time I want to take a very complex from into design view or save it after amending it in design view, it takes ages to save. All I can think of is that I make all my queries in the Form e.g. if I have a list box I will have saved the query in the row source of the list box instead using VBA ...

Hello, I am working an an app developped in VBA/Access, and I would like to call a macro (named AutoExec) directly from the VBA code of my program. I tried the following : Call AutoExec

I have a query that filters data and places the results in several text boxes on a form. I want to take the numbers in those txtboxes and use them as criteria for a different query. How do you take data from a txt box and use it as criteria in a second query?

Hello, I have an Access Database that I want to update using an Excel spreadsheet. When it is new reccords, I know how to do it. Nevertheless when I want to complete the information on a certain row of records which already exist, or if I would like to update it (ie: partially change certain records on a row), I do not know how to :

I'm hoping someone can tell me what I'm missing about how to open a browser and go to a website from a button or a link in Access 2000. I've tried designating a field as "Hyperlink type" and typing in an URL. I've tried using the Hyperlink field on the Button Properties sheet, and I've tried using Visual Basic: Application.FollowHyperlink...

Hi, I would like a sql query that would return the results of 3 selections as one column. For example I may have select title, forename, surname from details; but would like the results in one column, with the fields concatenated (with a space preferable between!)

In VB6.0, I can put an image on a form and assign it's .picture property at run-time. In VBA (within MS Access), when I put down an image control on a form, it asks me for the source to the image (at design-time). Why? Why can't I find PictureBox in VBA within MS Access? And most importantly...why can't I put either in a Report within MS...

i am inputting records using a form. how do i put a command button on the form that will copy the record i just input----sometimes i have the same record that needs to be put in 3 or 4 times and i would rather just be able to click a button and copy it.

What is the right way to do some calculation in MS access to be stored in the bound table through the user entry form. Should I make use of VBA or simply from access.

A97. I have a command button to save and exit. I had the code If Me.Dirty Then Docmd.RunCommand acCmdSaveRecord ...more code endif I was getting an error because a value was not getting set in the BeforeUpdate event. So I changed it to

Discovered this interesting comment on MSDN: "To programmatically obtain the hard disk's serial number that the manufacturer assigns, use the Windows Management Instrumentation (WMI) Win32_PhysicalMedia (a class) property SerialNumber." I'm sorry to admit it bit I am really undereducated on how to incorporate some of the Windows SDK...

I have the following code: Private Sub cmdDatasheet_Click() DoCmd.OpenQuery "qryCourse_Details" End Sub I would like to check to make sure that this above query has zero rows, then show a message box that says "There are no results in your query". I can not put the following code in the forms open event but that

Is there a function in VBA to convert a string to an array of characters. I'm looking for the exact same functionality as the ToCharArray() method in C#. If this functionality does not exist, do y'all have any pre-written code to do this? Psuedo-Hopeless Request- Dear Microsoft: It would be cool if VBA had more robust string manipulation...