Search results

Situation: I have form with two (2) datasheet subforms data1, data2 both subforms are based on the same table but different fields. The reason for this is that the company commissioning this database dont want to have to scroll across to view fields. Problem: The problem I am having is that...

Hi all I have a datasheet and when a user selects a record that record is highlighted by a dull colour (default) I wish to change this colour to a more prominent one, the simple question is how? Access 2007 Thanks for your assistance.

Form1 TabCntrl1 Subform1 - Datasheet FieldA = FieldB (FieldB unbound calculated changes daily) Problem: When subform is opened and records dispalyed (filtered by combobox Form1) only the currently selected record is updated. How can I get all records to update (= FieldB) when opened. I...

Hi All I am currently constructing a DB for a client and their request has left me scratching my head a little so any help is gratefully appreciated... We have a form that is connected to a projects table and a user would choose a project from a combobox and then a subform would display...

Hi Everyone I have a database that has a main form (frmMaster) on this form is a range of buttons (btn1, btn2 etc) I also have two (2) tables (tblUser) and (tblControls) related on a one to one relationship. The tblUser contains a department field and a password field and tblControl has the...

is it a good practice to build a form from a query (bringing together all tables for one form) or is best to create a form directly from the table(s) using subforms? Thanx 4 ya thoughts... My old man always said "Don't tell 'em son show 'em"

I need to import information from an XML file that includes a wide array or codes. Each code stipulates which amount is entered into a particular field. The importation and conversion is not a problem this has been achieved successfully, however the problem exist in the update procedure. Due...

HI ALL :) We currently are looking at importing xml files into our access database, there are three (3) files in all two (2) import perfectly however one (1) has problems. The problem is that one field name is greater than 64 characters. Is there a way we can either truncate this on import or...

Hi All, Here's a puzzle I hope someone can help solve, I have a database (great start) that has an extensive array of event procedures on its form to calculate dates etc. However as a lot of these procedures are on after update events when data is entered directly into the table the form wont...

I currently import data into my db however the date format of the db is short date 12/06/2004 but the date format that is imported is 12JUN2005. I need to convert the imported date format to that of my db. I also believe that the date imported is a string which makes it even harder.

How do I open a file within access and if I did how would I construct the code to open a file that part of its name can change. I don't want the user to have to interact using the file open dialogbox. Thanx