Unbound forms and dao recordset question
Mon, 22 Dec 2008 14:23:01 -0800
I have an unbound form I would like to use for entering new records (only).
I have deliberately chosen to separate entering new records and
viewing/updating previously entered records due to some factors of my
database that would make is difficult to accomplish both tasks with the same
form. On my data ent ...
|
How is 869343 less than 869330?????
Mon, 22 Dec 2008 13:52:02 -0800
This is the code that for some reason isn't following standard mathematical
logic. In my current record, Me.Odometer = 869343. The last Odometer
entered was 869330. My Invalid Odometer message pops up. I put a code break
to see what's happening. varPrevOdometer is showing 869330 and Me.Odometer
is showi ...
|
istext ???
Mon, 22 Dec 2008 13:33:00 -0800 (PST)
I have this code that I'm trying to fix. The data type on a field
(Field_Ticket_Number) was changed from integer on the back end to
nvarchar. I'm a beginner and am trying to figure out how to make this
code work now with a string instead of number:
Private Sub dbo_Field_Ticket_Header_Field_Ticket_Number_Befo ...
|
How can I know recordset count changed
Mon, 22 Dec 2008 12:31:05 -0800
Hi guys,
I have some details information of a record which is placed in the form
footer in a continiouse form. I should hide the footer if there's no record
in the form. since it's a multi-user form, the record cout might changed by
other user and I may get the latest records by refreshing manually.
The ...
|
delay in updating
Mon, 22 Dec 2008 11:05:05 -0800
I have what seems to be simple issue - but can find no documentation on this.
The refreshing of forms doesn't seem to follow the order of VBA code. Or
maybe the issue is that the speed at which things refresh cause it to appear
that the order is different. Here is the code:
Private Sub Returned_AfterUpda ...
|
Access Form Question
Mon, 22 Dec 2008 09:36:19 -0800
I have a form that has a search capability. The user puts in the account
number and it sends a pass through query to a SQL Server to retrieve the
data. The data then populates the form by changing the forms source to the
query. If the query doesn't retrieve any data the form goes blank. The text
boxes and bu ...
|
Custom Autonumber Help
Mon, 22 Dec 2008 08:24:49 -0800 (PST)
Hi All,
Some one once created a very simple put useful auto number generator
the following code was used, and did what i needed.
Private Sub Form_Current()
If Me.NewRecord Then
Me!ProjectQNo = "Q" & _
Format(CLng(Nz(DMax("Mid(ProjectQNo,2,4)", "tbl_Projects", _
"Right(ProjectQNo,2)='" ...
|
|
|
How To Use a Form To Specify Input And Output
Mon, 22 Dec 2008 08:10:00 -0800
I have a task to read in a pipe delimited text file and output the same file
to a tab delimited file. I am to include a form to specify the input and
output and add a button on the form to run the conversion.. I cannot use any
macros to perform the conversion. (i.e. TransferText).
I am new to Access progr ...
|
Major Advise Needed
Mon, 22 Dec 2008 07:19:42 -0800 (PST)
Hi All,
Need some help, cant seem to get what i want to work?
So I have a fully working Database that is populated with Enquirys?
and one of the fields i have added is a "Exporttocontracts"
Ive then created a separate table in a contacts back end, and the
theory behind what i want to do is all the project ...
|
Please help with multiple choise
Mon, 22 Dec 2008 06:58:00 -0800
If Ct1=1 then st=1
if Ct2=1 then st=2
if ct3=1 then st=3
if ct4=1 then st=4
if ct5=1 then st=6
If more than one of above marked then st=5.
How can I do that in VB ?
Thank you all in advance! ...
|
