hi all.... new to this so please forgive my ignorance...
on a normal html page i can call java popup code using the href property of an image to call up a single popup html page with the contents i require.... (i only need the blank page for the popup not one for each picture i want to pop)
how...
here's the problem......
i have a set of user entered fields;
[capital item name]
[start price]
[start date]
[tax year end] (that's the tax year end applicable to the item)
[write off amount year 1] (percentage of start price to write off in year 1)
[write off amount year 2 and on]...
here's the problem......
i have a set of user entered fields;
[capital item name]
[start price]
[start date]
[tax year end] (that's the tax year end applicable to the item)
[write off amount year 1] (percentage of start price to write off in year 1)
[write off amount year 2 and on]...
ok ...i've got a field on a table which is for invoice number.
i already have an auto number for the table id.
i need to be able to enter a start number in another table
and get selected records in the first table to update the invoice number field incrementally starting from the start number...
hi all... i'm having trouble and i'm not totaly sure this is the right forum... but i need help.
i'm deploying an access database via an instalation from cd.
i won't be around when it's installed and i know from past experience that when the install finishes and the program is launched that the...
hi all... i'm having trouble and i'm not totaly sure this is the right forum... but i need help.
i'm deploying an access database via an instalation from cd.
i won't be around when it's installed and i know from past experience that when the install finishes and the program is launched that the...
ok i know i need a runtime version of the latest database so how do i go about getting a copy of ms access runtime and it's atendant installer....
ps i have no dosh yet so it needs to be free!
i need to hide the charachters as they are entered into a password field....... got to be some kind of format thing.....
ps the real charachters are entered to a table for comparison ot another field.
i am trying to get the access options i set to load to a client's computer when i install my newly developed database.
specifically i have set the options /edit/find menu to all be off.
however when i install on the clients machine his options take over and all the actions queries which happen...
i am trying to allow a client to use the return key in a memo field in order to do this.....
instead of having to run to the end of the line and have the text wrapped........ how please???...... pretty please.
i have written an installer for the database which works fine , but i'd like to pass...
i'm trying to automate the naming of files from access...
i enter the path and file name of an image
eg... c:\pics\original\file001
and the database generates a new file name based on criteria entered into it...
so far so good, but i want to be able to click a button and have the database rename...
i need to hitch my front end to a different dataset on the fly .
in other words i need to use another datasource ie set of tables called the same as my master set with the samer relationships etc.
once a year all the tables are copied into pre existing empty databases... then when the user...
i,m trying to get a report/query to concatenate fields, place carriage returns after each field and print with no blank lines..... it drives me cwazzzzzzy!!
any ideas?
anyone got the right syntax to calculate....
the fields i have are...
[tax year start] (short date)
[tax year end] (short date)
[start date] (short date)
[purchase price] (currency)
[write off year 1] (number)
[write off year 2 and beyond] (number)
[proportional check] (check box)
[res bal fwd]...
i need to work out a figure based on a [start date] and the [5th april] each year....
so my start date may be 12/01/2002.... how many days till the next 5th april? =x
or my start may be......01/01/2003.... how many days till the next 5th april? =x
or my start may be......01/06/2003.... how...
i need to rename a table with the a date stamp so that each time the code (er sorry...macro) runs it renames a table with a date or number consecutive with previously renamed tables.
ie.
rename table xxx to zzz&(date())
thanks in anticipation.... kimbo:))))))) mr macro....sorry, not clever...
conditonal expression NOT WORKING
how do i?......
DatePart("m",[Forms]![PSWRDCHKFRM]![Text4])=1 And DatePart("d",[Forms]![PSWRDCHKFRM]![Text4])>28<30 And [Forms]![PSWRDCHKFRM]![ARCHIVE DONE]=0
IF THE DATE IS JANUARY AND THE DAY IS GRETER THAN THE 28TH BUT LESS THAN THE...
GET A DATE FIELD TO UPDATE TO ONE YEAR ABOVE WHER IT IS ALREADY?
i'm running an end of tax year update.... so loads of things are happening at once, ....so far they all work but i need the date 05/04/YYYY to change to 05/04/YYY+1 ......(datepart YYYY +1)?
pa i'm running an update query so what...
help with conditonal expression
how do i?......
field a
b
c
d
e
f
g
h
i
i need to make a conditional calculation.... on fields h and i
...h= if g-c= or <0 then h=0
if g-c>0 and <e then h=((g-c)/100)*d
if g-c= or >e then h=(e/100)*d
...i= if g-c<e then i=0
if g-c>e then...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.