Microsoft Access / VBA Forum

Hello all, Due to the size restriction of VBA code length I am forced to seperate my code accross Functions and call to them. The setup is simple I have a private function that runs...Within that function, based on a recordcount # it then calls a separate function. The problem I have is that it uses values detemined in the private...

Can some one tell me the code required to do the following: When my form called Welcome opens I want one text field to be visible for 5 seconds, then i want to make another field visible for 5 seconds makeing text field 1 invisible. After these 10 seconds, I want to close the form. Any help would be greatly appreciated. Regards,

I have created a mileage report in access. I created a calculated field called "mileage value" that takes field Mileage x field IRSRate. Each is for a given date field in a table. This works fine in the report. What I would like to do in the report is now Sum all of the mileage values (shown by date)for a grand total at the end of the...

Description Steganography is the act of hiding a message in plain sight. How Steganography Works One popular implementation is to take an existing image file and manipulate the bits to hide a message without noticeably changing the image or increasing the size. It does this by taking each byte that represents a color in a pixel and changing...

Hi all, Having done this Public Const JMCTITLESTRING As String = "New Arrivals 2008" and this Set prpTitle = NAdb.CreateProperty("AppTitle", 12, JMCTITLESTRING) NAdb.Properties.Append prpTitle Application.RefreshTitleBar I can do this, in the immediate window ? currentdb().Properties("AppTitle").value

Hi, I have a continuous form based on a query ( I will also be creating a report based on the same query). There are 2 fields: Date Obtained and Date Of Expiry I want a further 3 columns to the right of these 2 fields to show the

Hi everyone. I'm creating an application inside Access 2007. The application will retrieve data from various locations on my company's network servers. Depending on the time of day, alignment of the planets, other unfathomable mysteries sometimes my company's network is very, very slow. I would like to provide the user of my application...

hi there, I have a field called DateEnacted (data type :date/time) could anyone tell me how can i change the format to dd/mm/yyyy , when i enter values in the table, instead of mm/dd/yyyy? thanks, Kathy

I'm trying to save a result data into a variable but i don't have a clue on how to do it... can anyone help me with this?.. i'm pretty sure that this is wrong but this is what i'm trying to do Dim product as String product = DoCmd.RUNSQL = "SELECT product_name FROM product" let's just assume that the query returns only a single...

Hello Does anyone know how can I get the status of Caps Lock; Num Loc;k Srcoll lock? using access 2007. Regards,

I have a form with a Combo box and a button. I want the user to be able to choose an option in the combo box, click the button, and a related .pdf is opened. The Combo box has a control source in a table. Within the same record as the control source, a 2nd column contains a hyperlink with a file path to a related .pdf. What I am struggling...

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

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

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

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

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.

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.

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

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!)

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

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

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

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