| |
thread by: nspader |
last post Jun 17 '08 by: ADezii
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...
|
thread by: chris |
last post Jan 23 '07 by: missinglinq via AccessMonster.com
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,
|
thread by: Daryl Austin |
last post May 16 '11 by: Daryl Austin
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...
|
thread by: Rabbit |
last post Aug 2 '12 by: Frinavale
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...
|
thread by: JustJim |
last post Feb 25 '08 by: NeoPa
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
|
thread by: carl.barrett |
last post Nov 13 '05 by: carl.barrett
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
|
thread by: sphinney |
last post Oct 27 '08 by: NeoPa
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...
|
| |
thread by: kathnicole |
last post Sep 26 '07 by: kathnicole
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
|
thread by: czach |
last post Oct 11 '10 by: dsatino
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...
|
thread by: wassimdaccache |
last post Oct 16 '08 by: ADezii
Hello
Does anyone know how can I get the status of Caps Lock; Num Loc;k Srcoll lock?
using access 2007.
Regards,
|
thread by: Chris24 |
last post Sep 10 '10 by: Chris24
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...
|
thread by: Johnny Meredith |
last post Nov 12 '05 by: David W. Fenton
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...
|
thread by: Marcus |
last post Nov 13 '05 by: Arno R
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
|
thread by: Lauren Wilson |
last post Mar 15 '06 by: Lauren Wilson
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...
|
thread by: Salad |
last post Nov 12 '05 by: Salad
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
|
| |
thread by: mhegazy |
last post Aug 26 '12 by: NeoPa
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.
|
thread by: dgrabuloff |
last post Feb 27 '08 by: NeoPa
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.
|
thread by: Ed Landau |
last post Nov 12 '05 by: Ed Landau
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...
|
thread by: C L Humphreys |
last post Nov 12 '05 by: Tim Mills-Groninger
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!)
|
thread by: my-wings |
last post Nov 23 '05 by: my-wings
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...
|
thread by: Nono |
last post Nov 13 '05 by: Nono
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 :
|
thread by: tomric |
last post Jan 27 '10 by: TheSmileyCoder
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?
|
thread by: nartla |
last post Dec 4 '07 by: bobh
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
|
| |
thread by: iheartvba |
last post May 22 '12 by: darekk
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 ...
|
thread by: kjhyder |
last post Jan 17 '23 by: kjhyder
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...
|