|
History File
At the end of the business day I want to hit a command button and have
all of the records from "Sales" and "SalesDetails" move from Database1
to "SalesHistory" and "SaleDetailsHistory" in Database2. I then want to
save the last "SalesID" from the "Sales" table, Delete all of the
records in "Sales" and "SalesDetails" in Database1, then finally when
the new business day starts be able t...
|
4 |
09.09.2006 16:55:01 |
|
|
Ms Access HElp Reposted
Allen,
Thank you for you help I have managed to get it up and working!!
Can I ask you another questiong re your AppInventory?
I was to create a report based on the stock tootals created what is the best
way of doing this as the code which you provide requires for you to enter
the prouct code in order to get a total.
Any advice is much appreciated!
Thanks again
"Allen Browne" &l...
|
1 |
09.09.2006 16:27:23 |
|
|
Rounding down a value
i have a value in a table, lets say £1234.56.
Is their a function i can use to round this value down to the nearest whole
number?...
|
3 |
09.09.2006 15:49:43 |
|
|
Dlookup condition result
I have the following code on a form:
Form_Close
Link = "[DocId] = """ & Me.[DocId] & """"
DoCmd.OpenReport "Detail", acViewPreview, , Link, acNormal
And, this in its subform:
Code_Afterupdate
Me.Name = DLookup("Name", "Products", Me.[ProductCode] = [ProductCode])
Me.Price = DLookup("SalePrice", "SalePrice", ProductCode = Me. ProductCode)
The problem is that no matter which ProductCode ...
|
5 |
09.09.2006 14:38:02 |
|
|
outcut
how can I make an outcut into an irregular form?
--
gunda b...
|
3 |
09.09.2006 13:28:38 |
|
|
Best way to display a chart on MS Access 97 form
Hi, i need to display a chart on my ms access 97 home form so that
everytime you one the access application it displays an updated chart
about number of projects complete, late and very late. I have created
a query for each of them to return a count.Then i built a table
(tbl_project_info) so that complete, late and very late fields do a
lookup to their queries. Then create a chart according
...
|
3 |
09.09.2006 11:59:40 |
|
|
other solution to If-Then?
Hi all,
I got a code for my command button to open different forms depending on
values of different fields. Luckily it works all right, but i suspect there
could be another solution here (like, may be, "select case" or smth else?)
instead of such a long code... Does anybody have any suggestions?
Private Sub Command0_Click()
On Error GoTo Err_Command0_Click
Dim stDocName As Stri...
|
5 |
09.09.2006 11:11:28 |
|
|
error code 3251
hi there, i have a problem with my query in my coding. i will just include
the fragment of the code relevant as the entire thing is too long.
Dim qry2 As String - a query
Dim childm As Integer - number
Dim strresult As String - text
qry2 = "SELECT child_id_1, child_id_2, result" & _
"FROM tbl_stay_results" & _
"WHERE (((result) = ""...
|
8 |
09.09.2006 04:25:02 |
|
|
How do i close one form when i open another by button command?
I have a form that ive created for work to enter patient data etc... Problem
is, that i use command buttons to navigate from one form to the other. This
tends to leave many forms open as people navigate through. Is there a command
code i can apply to each button so that it closes the current form when i
move to the next, aswell as execute its own command???
Would GREATLY appreciate your...
|
4 |
09.09.2006 04:11:12 |
|
|
CmdButtonInVisible
I have cmdbuttons on a continuous form with links to files in a directory
outside Access. Is there a way for me to make the cmdbutton invisible if the
corresponding file is not in the directory??
Thanks You in Advance...
|
4 |
09.09.2006 02:25:02 |
|
|
I get a error in form
Hello,
I have a problem with a form with in my database the error massage is:
The form or name is misspelled or the refer to the form does not exist?
I try to locate the misspelled form name, but the name seem to be spell right.
Please help
Jeffrey
...
|
3 |
09.09.2006 01:22:30 |
|
|
Arrow Keys
Hi,
I need to be able to navigate between fields in a form by using the arrow
keys (up, down, left, and right). Does anyone know how to do this? Your
help is greatly appreciated. Thanks in advance.
Phil
...
|
3 |
09.09.2006 01:20:50 |
|
|
User defined date format
Hello,
I need to allow the user to enter a new date in the format "mm/yyyy". I
have set the field up in the table as a date/time data type and have added a
new input mask using the Input Mask Wizard as "99/000;0;_", named "MthYr
Date". I leave the Format property field on the General tab blank. When I
close the table, the Format property reverts from being a blank to Short
Date, bu...
|
2 |
09.09.2006 01:11:28 |
|
|
Create 2-texts box with buttons like the Query Wizard
I have main form. On this main form I need to create 2- list boxes. One
list box will have the list of items and the second list box I will need to
click on a button to have the secon list box populated. This should function
just like the Query Wizard(simple query) where on the left is a list of
fields and you click on the buttons to add or remove fields from the list box
on the right.
...
|
4 |
08.09.2006 22:26:02 |
|
|
Placing Customer Order
When i place a customer order,i first go to frmCustomer where i enter
the customers details. I then have a button that opens up frmOrder to
place the order.
The problem is that i have to type in the customer ID number in on the
form.
Is there any way when i click place order on frmCustomer it will
automaticl put customer ID number on the Order form.
Thanks
Simon
...
|
4 |
08.09.2006 22:21:02 |
|
|
Conformation yes No question
For when i click the order button on my database is there a way that i
can have a messagebox to come up to ask if i am sure i want to place an
order with a yes and no click boxes
Thanks
Simon
...
|
2 |
08.09.2006 21:24:02 |
|
|
Full date and day
On my order form i have delivery date field. I now have a button that
creats an email to tell the customer the delivery date.
in the VB code i have used me.deliverydate. This puts the correct date
on the email but its in the following format 8/9/2006 but i would like
it in the following format Friday 8th Septermber 2006.
I also have on the email the delivery time using me.deliverytim...
|
2 |
08.09.2006 21:12:40 |
|
|
Delete Filter and OrderBy when opening
Is there a way I can delete the Filter and OrderBy properties of my form when
it is opened? Thanks....
|
2 |
08.09.2006 20:14:13 |
|
|
dao and ado
Access 2002, xp
Is it ok to set references to both ado and dao libraries?
after using this code
Dim thisDB As DAO.Database
Dim thisRS As DAO.Recordset
I am getting this error:
compile type:
user-defined type not defined
and then when I go into debug mode this code is highlighted:
Private Sub cboBCity_NotInList(NewData As String, Response As
...
|
3 |
08.09.2006 19:52:09 |
|
|
more than 1 bound column?
I have a combobox looking at a separate table and the first column of the 3
columns is bound.
Can I bound another column also?
--
NTC...
|
3 |
08.09.2006 19:45:26 |
|
|
SQL on the fly...?
I've got some code that works (yeah, really!) that I want to use in my After
Change of a ComboBox. It defines a Query that looks at the result of the
changed Combobox and of an unbound List box (containing only three items),
and then filters the main data based on those two factors.
I have my code set up as
dim SQL as string
SQL = "SELECT Company.CompanyID, Payload.PayloadID, Item....
|
8 |
08.09.2006 19:03:07 |
|
|
Perform sql statement without using it as a recordset
Hi,
I have a booking system which has an individual and course assigned to
each booking.
Each course has a course class.
Each individual has a specification form which displays all the skills
a individual has.
When a booking comes in the class of the course is added to the
specification of the individual who booked.
The individual table has a few columns which are all checkboxes on t...
|
2 |
08.09.2006 18:46:02 |
|
|
Open Event Not Firing?
I have the following code that runs when you click a command button. I have
further code that is supposed to run when the open event for the "Allocate"
form opens. For some reason, that code is not triggered. Any ideas?
Thank you kindly for your time.
This code is contained in a form called "Punch"
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
Private Sub cmdAllocate_Click()
Me.txtTimeToday.Set...
|
6 |
08.09.2006 18:45:40 |
|
|
Automatically Scroll or Page Down/Up
I have form with alot of information for the user to enter. It has sections
of info on it.
So I want when a control gets the focus to automatically scroll down (the
scroll bar). So the whole section of info can be seen instead of user having
to manually scroll down or page down.
Can you use VB code to automatically scroll up and down a form? Thanks for
any help.
...
|
4 |
08.09.2006 18:05:58 |
|
|
list box text
I have a multi-select textbox and when it is set to disabled, I want to set
the weight of the text in the text box to be extralight. Currently when you
disable a text box, the text remains regular or bold - whatever it was set
to - just the background changes to a "gray" colour.
I tried setting the textboxes fontweight in code and it did not seem to work
at all. I must be missing the pr...
|
1 |
08.09.2006 18:00:19 |