Ok - to simplify, I have a report like so:
RefNo Name Paid Method
1 X £50 Cheque
2
3
4
5
6
7
8
9
10
11
12
etc
I would like to have:
RefNo Name Paid Method
1 x £50 Cheque
2
3
4
5
6
7
8
9
10
Space or line here (after every 10 records)
11
12
13...
Hi all,
I have a simple report that has 4 fields based from a query. The 4 fields are RefNo, Name, Amount paid & Payment method. This report is printed on a daily basis & is grouped simply by Name ascending. On a daily basis we have a report that shows all payments from Names A-->Z &...
Hi Bob,
I've taken both tables & did what you said. the data field Sort is the added autonumber
Here are the last entries from the corrupt table
Sort Tref Month Amount Sent
26480 12102 01/05/2004 £0.00 No
26481 12103 01/03/2004 £0.00 Yes
26482 12103 01/04/2004 -£7.50 No...
Hi Bob,
I did try that last 40 method but it didn't work with my table. Of the 4 fields in the table, 2 constitute the Primary key with one of them being related in a one to many relationship with the main table of our database, which is an autonumber. That number is pulled out of the...
Bob,
I appreciate your help, unfortunately I'm not too hot on my SQL. I understand what the code is trying to achieve but when I write & try to save it I get an error of: Syntax error (missing operator) in query expression "(B.ID) IsNull". I've also noticed that some of the data fields in...
Hi everyone,
One of the tables in our database corrupted. It contains 4 data fields & has 40 records in it that have been added since our last backup. I would like to find the records that aren't in our backup so I can manually/ update the uncorrupted table. I know this can be done...
Thanks for the replies - technome i think you're right. We only have an 0.5 Mb ADSL connection with Upstream of 128Kb/s. ( Unfortunately we can't upgrade our connection due to location ) I will add more RAM & hopefully this might increase the Remote Users experience.
Cheers,
Kilt
Hi Romh - I had the same problem as you (& stll do). i couldn't open our access database over VPN so i started using TS. The database can now be opened but some of the larger queries make the database unstable & we have a 1.8 Gb Pentium 4 CPU & 1.5 Gb RAM + this is when there is only one user...
Hi everyone,
My boss & 2 others need to work on our access database, remotely. I've got them connected via VPN & TS but they're complaining that it's very slow when querying etc. I know the speed is going to be less than on the LAN but does anyone know of any way to speed up the...
Thanks for the reply. I've tried TS - it works but the end user says it's too slow so I'm looking at 3rd party applications to speed things up. Any ideas?
Thanks,
Kilt
Thanks for the replies guys. I've tried TS - it works but the end user says it's too slow so I'm looking at 3rd party applications to speed things up. Any ideas?
Thanks,
Kilt
Hi everyone,
I set up a VPN to Remote Access into our Access XP database. After a lot of "hair pulling" I finally managed to get our users, access to our Network Shares. Unfortunately we can't open our access database. It's Access XP & the Kb article to support the error...
Hi everyone,
One of the main reasons to set up our VPN was for Remote Access into our database. After a lot of "hair pulling" I finally managed to get our users, access to our Network Shares. Unfortunately we can't open our access database. It's Access XP & the Kb article...
I had exactly the same problem & did the same standard fault finding as you. Eventually I found Kb 325930 which solved the issue. I think it'll work for you.
Regards,
Kilt
Hi all,
We’ve just set up a new LAN. We imported our old message folders from O/E 6 into the new Profiles that use Outlook XP. In Outlook I’ve changed it to be the Default mail folder, both through Tools / Options / General & through the Internet options – choosing it as the Programme...
Hi everyone,
I've set up an SMTP mail feed with our ISP. I can send out mail to any email address but can't receive mail. Our ISP says that they get "connection refused" at their end when they manually try to forward our mail to us. Our smtp virtual server is setup for our...
Hi all,
Rolling out Exchange for 1st time this w/end & I can't figure out how to assign an e-mail address xyz@xxx.com to more than 1 user. Any help appreciated.
Thanks In Advance,
Kilt
Hi everyone,
I need to know if there's a way of taking a snapshot of all data added into a database on a daily basis so that i can send it by secure e-mail. The problem is my boss lives in a rural area & cannot get broadband or satellite coverage. What I'd like to do is give him the...
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.