|
|
|
|
3 |
90 |
|
|
Query Problem by
Bre-x
Hi,
I have a table that has a date field = MM/DD/YYYY = 12/31/2004
I have this function that helps me to query my table:
Function CR(FY, FM, TY, TM) As...
|
|
3 |
487 |
|
|
Caps Lock by
Bre-x
Hi,
is there a way to find out if the someone is using upper or lower case?
It's for a login window and the Password field must be on Upper...
|
|
2 |
61 |
|
|
|
December 21st, 2005 07:20 PM
by Klatuu
|
1 |
79 |
|
|
Query Question ( equal to or like) by
Bre-x
I have setup a function to query work orders
When the user enter a work order number the function get the info.
How can i modify it so that the user can enter...
|
|
1 |
76 |
|
|
The last day of the previous week query by
Bre-x
Hi,
How do I get the first and last day of the previous week?
I seen current week, but nothing about previous week
The last day of the current week:
Date()...
|
|
2 |
76 |
|
|
FORM CLOSING PROBLEM by
Bre-x
I have a form (SW) with one single object, a text box (EMP).
I get an error: This action cannt be carried out while processing a form
event
What i want is...
|
July 12th, 2006 08:40 PM
by Klatuu
|
3 |
50 |
|
|
setfocus doesnt work by
Bre-x
I have this code on a text box control (tfind) How come the focus does not
go back to it? It goes to the next control
There is something wrong with my code,...
|
August 9th, 2006 07:01 PM
by Bre-x
|
2 |
71 |
|
|
Trim function by
Bre-x
Is there a way to use VBA to trim and entire record?
I have a table that has 37 columns, each column need to be "trim"
I know that I can create a update...
|
|
9 |
77 |
|
|
Parsing problem by
Bre-x
hi,
I have this query that I am using to parse this data 12345-1 into 12356 and
1
SELECT INVS, Right$(,Len()-InStr(1,,'-')-1) AS...
|
|
1 |
75 |
|
|
Running Sum by
Bre-x
Hi,
I have a table with the folling data (Where R means Received, and S means
Shipped)
TranType Partid Qty
R W293 3
R ...
|
|
4 |
67 |
|
|
Denormalizing a Table by
Bre-x
I know I posted this question time a go, but I have to keep trying
I am connecting MS Access to a Pervasive SQL Server with a very old table
structure...
( 1 2)
|
|
10 |
214 |
|
|
call shell by
Bre-x
Hi,
I have a MS Access 2000 db that uses the command
call shell to launch a program that will clean up a text file.
My question is: is there a way to use the...
|
September 24th, 2004 03:21 PM
by Bre-x
|
2 |
87 |
|
|
sql views by
Bre-x
Hi
We are using MS Access 2000
I need to send to a pervasive sql server the following sql commands
drop VIEW vw_test;
Create View vw_test As
SELECT...
|
|
2 |
92 |
|
|
Pass-Through Queries by
Bre-x
Hi,
Can you modify the sql statement of a pass-through query using VBA?
Thanks
Bre-x
|
November 9th, 2004 08:36 PM
by Bre-x
|
2 |
92 |
|
|
previous field by
Bre-x
Hi,
I have this function on a datasheet form.
It doesnt work. After i click Ok, the focus doesnt stay with the RQTY
field, it actually moves to the next...
|
|
1 |
90 |
|
|
Help with while ...loop Statements by
Bre-x
Hi,
I have a table where there's a "R" field (Yes/No Type)
For every record where R equals to -1 I have a function that do "something"
I am able to...
|
|
8 |
86 |
|
|
deleting a field by
Bre-x
Hi,
can a Table field be delete by VBA?
Thank you all
Bre-x
|
|
3 |
89 |
|
|
waiting for another application to finish by
Bre-x
Hi,
I have a db that send some data to MS Word (invoices).
On MS Word a have a macro the print the document (PDF Printer)
then on MS Access I have a function...
|
|
1 |
85 |
|
|
missing numbers by
Bre-x
Hi,
Is there a way to find out what numbers are missing?
Example
Field: MyNumbers, Type: Integer
1,2,4,6,7,8,9,10
|
September 7th, 2006 10:35 PM
by Bre-x
|
2 |
89 |