Search results

Hi guys, Just a quickie about Tab Controls. So that I can format them to match the rest of my forms, I have done the following: Set the backstyle of the tab control to transparent. Changed the tab control style to None (after creating the individual pages). Placed buttons on the main form with...

If you change the form so that it shows continuous forms instead of datasheet view you can use the following code on Form Dtl Dbl Click event: Private Sub Detail_DblClick(Cancel As Integer) Dim stDocName As String Dim stLinkCriteria As String stDocName = "Form2"...

asp.net 2.0 alternatively check out http://www.asp.net and have a look at the .net framework. You can download Microsoft Visual Web Developer Express free of charge and it has a built in web server (handy if ur not using 2000/XP prof). The site also features some great video tutorials showing...

apologies for the question... realise this now. Having read more into normalisation I am using SQL lookups to queries and storing the ID (integer) values in my tables.

Hi, Could you not put in the page_onload event If page.ispostback = false then 'submit form Else 'return to page1.asp Just started learning asp.net 2.0 so may not be correct. But in theory this would only pass the information to the php page the first time the form is submitted (when...

Limiting Number Of Record Entries Thanks, Should be able to get what I need from this. Dont really want a message box displayed, just need to show the user only one blank record to enter data into (on continuous forms). Presume I can add the me.form.allowadditions = false to run after a...

Hi guys, What would be the best control source to use for my sub forms detailed below: I am designing an Asset Management System. Each the main Asset Table "TblAssetMain" has child tables "TblAssetType", "TblAssetDetails", "TblAssetEventLog". When a new asset is created, the AssetMain form...

if you have done this in VB you could asign a variable to the textbox i.e. Dim TableName as String TableName = Me.YourTextBox SELECT [LOAD], [Displacement] FROM TableName Not sure if you can call the variable within the SQL Statment in this way as am still learning myself.

Hi Guys, Just created the following routine, wondered if I have gone about it correctly? In my database (of IT Equipment), each Equipment_Type_Table has a relating Specification Table. The name of the Specification form is stored in the Equipment_Type_Table. When a new product is entered on...

Hi Guys, Just created the following routine, wondered if I have gone about it correctly? In my database (of IT Equipment), each Equipment_Type_Table has a relating Specification Table. The name of the Specification form is stored in the Equipment_Type_Table. When a new product is entered on...

Hi Guys, First off, a big thanks to everyone on the site. I have learnt a lot since first discovering this site a few weeks back. Problem: Having understood that it is better to create SQL lookups to queries of tables rather than to the tables directly, I am having trouble understanding what...

Colour Changing Forms Thanks. That will do the trick. Should be able to amend the code to include properties for other controls too. Thanks again Ben :)

Hi Guys, Being primarily a webhead, it is possible to have something similar to a Stylesheet (CSS) to control the fonts/colours of all my forms and their various controls? I was thinking that if i created global variables i.e. dim bgcolor as Interger bgcolor = 13256464 (color value) then...

Database driven websites If your looking to create a database driven web application then a good starting point would be ASP.net 2.0. I have just started learning this myself and it provides connectivety with Access databases. You can also download Visual Web Developer Express 2005 from...

autofill Would have thought you could do an update query. Stick the field in that you want to update and set the criteria for all records where the value is "" Still new at this so someone else may have a better solution

So the make table function.....?? I wouldnt say that I was exactly new to Access, nor to the concept of normalisation. Much better to have the Equipment_Type_Specific_ID in the actual spec record as it would make it easier to link (thanks). All I want is a function to create the tables, the...

Hi Guys, Would like some advise on my database structure. I have a main Asset Table recording IT Equipment. Two of the fields in the Asset Table are Equipment_Type and Equipment_Type_Specific i.e. PC > Desktop There is an Equipment_Type table with a child table Equipment_Type_Specific The...

Not sure I explained it correctly... In a way to store the data efficiently, I did not want to have one specification table as you would have to create a field for every possible specification detail. For example, the specification record for a printer would have blank spaces for HDD, FDD...

Hi Guys. Just a couple of questions that I hope someone can help with. I have just started building a new IT asset management system. Each asset can be a different equipment type. In tblAssetMain the equipment type field is a lookup to tblequiptype. The user can then select PC, UPS, Printer...