Hi
Hope you can help me with some quick answers to these questions...
Does shrinking a db undo the index rebuilds?
Is the log truncated automatically after doing a full backup?
Ive a database with a 350MB table A (750K rows) and 90MB table B(3.5M rows), it comes in at 1.3GB on disk after backup / truncate/shrink/ index rebuild. The indexes are relavant i feel. I know that i should normalize table...
garyb2008
Last Activity: Oct 29 '09, 04:14 PM
Joined: Nov 7 '08
Location:
-
Quick questions About SQL Server 2000
-
All im doing is taking a pdf booklet and plodding it on the web (bad design basis for website i know, no need to say!), instead of making each whole page a graphic screenshot that sits in the centre of the webbrowser i want to keep the text areas as real text for seo purposes, as each page is a rectangle, would i not get away with a centred table and then use absolute lengths to divide the internal cells in this case just preserving internal lay... -
How do i put a border around my page
Hello
Ive designed a simple webpage using tables to lay it out. I would like to put a border around the outside of the it, sort of so that when it loads it looks like a poster. Ive though of creating a row top and bottom and then a column either side to hold pics of straight lines but would they always join up at the corners?
Also, if im designing for 1024 x768 screens, which i presume is standard now? What size should... -
Timeout expired Access 2000 project on execution of long Stored Procs
Hi everyone
I know a lot of people have this issue and have Tried changing the timeout in connection properties, but has anyone ever found a solution to this apart from run these at the server in Query Analyser?
Regards
Gary -
Should i learn ASP or Oracle APEX to create Online DBs?
My work now needs to share live data with the companies clients. Its simple stuff - based around one table with a few for aux info - and ive been using Zoho Creator DB but this isnt as solid as we would like...
Whats the best path for me to create these web databases?
Should i learn web page / ASP programming or is it easier/ better to learn the Oracle APEX platform (Express Edition)?
Arguments i already... -
Is my use of the AfterUpdate and Current Events dangerous?
Hi
I have a form bound to a stored procedure. I have made it that on changing the value of a list box the form moves forward a record.
I have done this using the afterupdate event of the list box. Initially the listbox was bound, but i noticed that when i automatically moved forward the listbox got out of sync with the record source. I got round this by making the list box control unbound and using vba to keep it in... -
garyb2008 replied to Passing Time Value To Stored Proc in through Input Parameters property of Form. ADPin SQL ServerMight be best to try the SQL Server Forum then Neo if you would
Thanks
GaryLeave a comment:
-
garyb2008 replied to Passing Time Value To Stored Proc in through Input Parameters property of Form. ADPin SQL ServerTo clarify
In the forms property page the recordsource of the form is set to the name of the stored procedure.
The Input parameters property of the form will contain the parameters that the stored procedures requires.
This works fine for stored procs that require integer or string datatypes eg
@intMyParam1 = 6, @strMyParam2 = 'xyz'
Would work fine, but i need to know the syntax to pass times...Leave a comment:
-
garyb2008 started a topic Passing Time Value To Stored Proc in through Input Parameters property of Form. ADPin SQL ServerPassing Time Value To Stored Proc in through Input Parameters property of Form. ADP
Hello All
Ive been creating my first access project in Access 2000 and SQL Server. Its up and running now for 35 users and has been pretty much a success, though ive been stopped in my tracks quite often to figure out how to get these applications to talk with eachother.
Todays problem:
I want to pass time figures to a stored procedure using a forms Input Paramaters property, namely @StartTime and @EndTime (both are... -
Hi Guys
Thanks for looking into this while i was away, was havin a time out from the project over christmas. I think ill go with NeoPa's solution for this, but im keeping your function ADezii's as with a few modifications it may solve another requirement i know will also be needed.
Happy new year all
Gary
Regards
GaryLeave a comment:
-
Calculating amount of time that falls into a specific range
Hello
Can someone help me with this one please! Im working on a service level tracking database which records the times that a service goes down during the day (DowntimeStart/DowntimeEnd) and compares this to the times that it is required to be available (SLAStart/SLAEnd). I want to return the amount of time the service was down during the SLA period in minutes.
...Code:Date, DowntimeStart, DowntimeEnd, SLAStart, SLAEnd 1/1/08,
-
Im quite new to this as weel, as far as im aware you can get the same effect as using JOIN by using a WHERE clause, in fact using the where clause is reffered to as the old style of joining tables.
The syntax is as follows.....
ANSI Style
select * from a join b on a.id = b.id
Old Style
select * from a, b where a.id = b.id
Is this what your getting at?Leave a comment:
-
When you add a subform to a form it gives you an option to set the subform to be filtered by a field on the parent form during the wizard, just choose the relevant fields on the forms.
Alternatively, to filter (any) form in VBA code, you set the forms filter property to a filter expression, and then set the forms FilterOn property to True.
eg.
Say you had an unbound combo box (named combo1) which lists...Leave a comment:
-
The phone call is only a notification that the delivery van is outside there location...Leave a comment:
-
I suppose youll have to decide the table structure for handling payments then
You could have something like
Table: Payments
Fields:
PaymentID
TenantID
PaymentDate
PaymentType
PaymentAmount
PaymentNotes
Table: InvoicePayments
PaymentID
InvoiceID
AmountofPayment
So when a payment comes in its Recorded in the Payments...Leave a comment:
-
Hi
Im sorry i follow you up to the point were you describe the subform, "it includes all of the options"???
Do you mean the subform has eight combos as well with the same drop down options as the main form?
Regards
GaryLeave a comment:
-
Dial a number and hang up as soon as its answered
Hi Everyone
Hoping we have some telephony guys in today... I want to make a fully automated VB app to be able to give a notification call to customers by ringing there phone from our office. I want to hang up immediately if the telephone is answered so as not to incur call charges (or at least as little as possible). Initially i want to do this via a modem.
Im assuming tapi would be used, does tapi have a feature which... -
Hi
I was thinking about this a while back for a project that never went ahead. At the time i was going to look at the Northwind sample database that comes with access to see if there was anything in there that could be used.
What is your table structure at the moment.
GaryLeave a comment:
No activity results to display
Leave a comment: