Bytes Tip of the Week #53 - How to Return Multiple Values From a Function
The incentive for this Tip was an Article by the amazing Allen Browne - I considered it noteworthy enough to post as The Tip of the Week in this... more »
sticky
|
|
POSTING GUIDELINES: Please read carefully before posting to a forum
1 Reply |
Posted by: PEB
| Last post by msquared, 530 days ago
POSTING GUIDELINES
Please follow these guidelines when posting questions
Post your question in a relevant forum
Do NOT PM questions to... more »
sticky
|
|
SQL WHERE Multiple Columns
Hi People
This database stuff is new to me and it's driving me nuts! I hope someone can help me with this problem? I'm posting to this forum because... more »
|
|
Access-update username and name of the file which is imported
Hi Experts,
I have got a MS-ACCESS database, where i import excel files into it. This file is kept in a network drive. So everybody can access... more »
|
|
If statement help
I am doing a monthly report for a company in access. I am fairly new to access so I don't know a whole lot. The report was orginaly created in... more »
attachment
|
|
Using a combobox to go to a selected form record
Hello,
I have a button which is beside a combo box . The user selects the patient ID (integer) from the combo box, then presses the button. The... more »
|
|
Validating the date field using VBA code
Hello guys,
New to this forum and new to access programing, my issue is
I am comparing 2 date fields, I have to validate that Order Rcvd Dt should... more »
attachment
|
|
Not Equal SQL Queries in Access
Hi Friends,
I have a problem with a particular SQL query which I wrote.
Just to brief on the Tables involved.
Beneficiary
Solar Lantern No -... more »
|
|
DCount issues.... again
Hello everyone
I have been useing Access for a while now and have attempted useing DCount a number of times but with varying results.
I am... more »
|
|
replace space character with underscore
1 Reply |
Posted by: n8kindt
| Last post by Stewart Ross Inverness, Today
hey guys, i have a function that can recognize a space character in a string... how can i get it to replace a space with a underscore character
... more »
|
|
Calculating Military Time
Hi!
I used Query in Access to calculate the time in and out of the employee of course to get the total minutes, however i've been encountered a... more »
|
|
Is an unchecked checkbox "0", or NULL?
So I have this form that captures Me.CheckboxName.Value as part of an SQL statement. For one checkbox, it evaluates as 0, which is great, because... more »
|
|
Open a form from a form based on two criteria
I have a database that has a client number with multiple records each with unique numbers. I want to "Bop Around" between the two forms as... more »
|
|
Email TO: Handling Blank Fields
I have a piece of Code that creates my TO portion of my email when I hit a button. The only problem is it can pull from 3 different fields. For some... more »
|
|
text function
Im try to catch the part numbers on a specifict field inside access query and I dont know what kind of function to use.
example data:
new order... more »
|
|
ODBC connection
I very new on Access scripting and I wanted to add on my event like load report and odbc connection so I can execute sql query besides the query... more »
|
|
Update Statments
Hi All
Please help me .Hope i have described my problem clearly below.
I have a condition where i need to update some data in table from the value... more »
|
|
Problem in running or open the query
Hi Everybody..
This is my firstime in creating report using microsoft access.
Actually i need to build a report based on a database call Table1.
I... more »
|
|
Major Crosstab
Hi there, I need a little help please.
I need to create the following report for a medical training school:
Course... more »
|
|
After update - If Like Else else
I have a field called and the value of that field can be deciphered into a location for that client.
Eg. SU023 = UK
SA024 = Australia
....so... more »
|
|
Get Most recent customer review
Hi All
I have a major problem with an access query and I am near the end of my tether!
I have taken over a project with a badly built access... more »
|
|
Problem populating combo box
I'm trying to populate a combo box on a form by inserting this query:
SELECT *
FROM menu
WHERE NOT submitted;
into the Row Source property of the... more »
|
|
LinkMasterFields property in subform of subform
Hello,
I've read through many forum posts on this issue today but can't seem to find a solution that fits my particular case.
I have three main... more »
|
|
select field names
Is it possible to select a tables field names using standard sql? more »
|
|
From a table to a form to a table
A friend helped me develop in VBA a form that allows me to simply enter a shipment number and freight cost, and then it adds the calculated data to... more »
|
|
Scan (OCR) into MS Access (form)?
Hi all,
Very new to this forum. Searched for relative postings but found none.
Question:
Does anyone know of any application that could... more »
|
|
ms access vba code to save record
hi guys need your help.
im trying to save a record to another table.
this is how it supposed to work...
form1 (table_A) contains NameID, Age and... more »
|
|
