i have found a downloadable demo on a site that has a module you can put into your sql/query that will work this out (in theory)
site url:
http://www.data-flow.co.uk/technique.htm
download url:
http://www.data-flow.co.uk/download/running_totals_2.zip
it has directions and everything,
Hope...
i'm writing a confirm screen for a system, i only want 1 record per screen, but i want to be able to switch through the records without confirming. ie. <last next>.
i'm opening the full record set, but only displaying the first record at the moment so i need to add into this a movenext applied...
We are currently setting up a user system using sql and asp. we want to print letters from this system.
In a letter, for the first page we have a header and a footer and for all subsequent pages we have a footer.
Is there a way of putting headers and footers in a flash file? please, i love you...
I want to log my servers out at 7 every night, but i want to leave work at 5!!
Is there an auto logout option in windows that will let me do this?
Cheers and Stuff
DaveSmith
What i'm trying to do is show a list of names in last name alphabetical order, then i want a text box somewhere on the page, if box is "" then shows all records, if text is typed into box then it refreshes that data to only show matching records!!
I know this can be done using a LIKE...
Someone has written a package which we plan to get some of our customers to use!
Problem is it exports and emails all data in comma delimited form!!!
What i want to do is get our staff to copy these files to say, the network in a temp file, then on our intranet/internet somewhere have an...
Why make it harder, in your report have you 3 columns
Username
Requests
Approved
Group by user name, if you want your text to be on one line
i.e, name 3 2
then leave the group by section empty, reduce the height to 0 and all your records will look in line with no gaps.
Field1 = username...
ok, i think i've got how to get the start/end date etc..
main problem is that i'm working with dates of birth.
14/10/78, 12/10/56, 04/03/80
i have also got to take into account these are pre 2000?
The info is from a different system which i am taking selective data from.
Meaning all i want...
I have a table, this contains personal details such as name, address, and Date of birth, this is what my problem is.
In the system i'm writing i want to have a screen which pops up after login with all a member of staffs' clients who have a birthday in say the next 21 days.
In access i managed...
If you have a table with your customer details in (unique codes) you could either run for all or selected, or even between dates, whichever query you run,
but you could do it like this
A = id table
B = sales table
open A, goto first record,
do while not A.eof
dim personID
personID =...
I was checking through some of our combo box coding and found this which pulled through vat months
<select name="vatMonth">
<option selected value="">Select...</option>
<option value="June">April</option>
<option value="September">July</option>...
I have read thread333-119488 and it makes sense to use the permissions on each folder to stop unwanted users to log in, unfortunately i need to go a little further, I am looking into the software that is featured on the same thread but i'm a bit dubious as to whether it does exactly what i want...
I have had a search through and i have found a file called AMIS.mdf (AMIS being the project i'm working on), but i'm going to try putting the other server onto the same intranet, export the database using the export option in sql.
This should work!! (i hope)
Dave
We are currently designing our new web based system using sql server as the backbone...
Now we have created it to an extent on our internal servers we want to transfer our data to another server which has links to our webserver (heaven forbid we would give people access to our intranet)
As we...
i am currently writing a mailmerge "on the net" type page for our customers, yet sql only lets you save in one font/bold/underlined etc in each field.
I have found a way round this, but what i want to be able to do is,
say i'm going to do a heading under the addres (which is picked up...
No....
I don't actually think its possible, the way i think i'm going to have to do it is....
Fields... LetterID, LetterSection, Text
i.e. 132 1 (in bold)holidays
132 2 section 1 of letter
and so on.
I'm working in ASP and so i will have to...
i'm trying to create a mail merge facility for our staff / clients to be able to enter the letter text in a field in sql, then use that through a web page to create a mail merge using fields from another SQL table.
But my question is, can i specify in a field differences such as allignment...
On an if statement ie. if not authorised user, i want to print to the screen, easy enough.
Then i want to redirect to another screen, again fairly easy.
But i want the person to be able to read the message, so i want to have a delay in there for say 3-5 seconds between writing and redirecting...
I am creating a report for on the screen, i also want to print it off. Can i enter code to automatically print the page in landscape from the browser.
Can i also set margins!!!!
Is this ASP or javascript, am i going to be able to do it?
So many questions........
Cheers
Dave
Shtop, Shtop, We have a misunderstanding.
I want all i want to know is how to accept/display data in a certain format.
In access i would go into the Input Mask and type (for this same code 12-12-12)
00-/00-/00, this would put the number in the field as 121212 but would accept entry 121212 and...
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.