Search results

If the size or user base is going to get that large, it may be worth considering SQL or mySQL from the outset.

I suggest you look at the use of sub-forms set to "continuous". Have a read and see if that looks the way to go.

You could use the line control, in a control array. Not the most elegent, but basically you size the line to fit the width (1 px high) of the screen and set to the start colour, add another below it and change the colour to an intermediate and so on till you cover the form. It would take a bit...

Shows when I last used Access for UI development!! Set the timerInterval = 1000 and have a form Level boolean "running" which you set to true as part of the click event for the button. In Private Sub Form_Timer() if running = true me.txtCallDuration.text = now()-txtStartTime.text end if...

I think the suggestion is that you don't have the stock calc table. By recording that dates that there is incoming or outgoing stock you can calculate on the fly the stock level for any given date.

Are you looking for: Private Sub OpenDoc_Click() FollowHypelink "C:\Documents.......\" & me.docn.text End Sub I wouldn't hard code paths, you'll come to regret it. Or at the very least declare a global constant so you only have to change it one place.

Access still uses VBA which is based on the VB 6.0 and earlier language. The move to .NET was the biggest change in the VB language to date. It is now a far more robust and functional OO development environment. While you can achieve similar results in VBA or VB6, the volume of available...

Firstly the in call counter: Put a label field on your form and a timer control. On the Click event of "StartCall", set the timer interval to 1 second (1000 IIRC) and set it running. In the tick event of the timer use TimeLabel.Caption = TimeLabel.Caption +1. You can use format to show as...

If the data is in Excel, why not use VBA in excel to do the task rather than messing about putting it in Access first? As mentioned, the FileSystem Object will provide all the functionality you need to rename files as well as providing other file handling features.

They look like validation routines to me rather than database updates. The PostCode returns a Boolean to indicate whether the postcode is valid or not, the first would just update the text in a field prior to a db commit. Select the field you want the checking to apply to In the properties...

Once you've added it as a reference it should be a case of: Dim myTest as new Test Then call the method on myTest blah = myTest.someMethod()

Going back to basics, I think you potentially have a DB design issue. I'd be looking at having a Delivery table and a Consignment Table, probably with a Packages table, so for any given delivery location you can have multiple consignments each with 1 or more packages. You then store arrival...

Not quite sure how you want this checking to manifest its self, ie a data update or something in the UI.

You've been given 2 functions, you need to pass the test data in to them. if fValidUKPostcode(me.<nameOfFieldWithPostCode>) = true then 'valid postcode Else 'invalid - show a warning and clear what has been entered, for example End if

I'd have at least 2 forms, keep the Client / Contact creation separate from the delivery creation, the former is likely to far more static. A combo on the delivery form will allow the selection of the Client and can then populate label(s) with the client details displayed. You can also design...

What sort of format are the offers in? If they are purely text then a timered form would be fine, if you need complex layout etc, I'd be tempted to publish to HTML / write and ASP / ASPX page to query the databse.

This strikes me as more of a programming challenge than a database design issue. Are you capable of writing your own controls? Have you looked for third party controls to assist?

I suppose the first questions are: 1) Is this a multi user app with the UI and tables separated? 2) Are you looking to plug in to a server mail solution such as exchange, write your own mail sender (not actually that hard) or use a client app?

A few assumptions here, but assuming a class is a teaching class and a student may be in more than 1 class you'll need an intermediate table to identify the actual classes that a given student attends. [Student]1-m[TeachingClass]m-1[SubjectClass] Use the combined foreign keys as the primary...