Search results

not directly, I know it can be done through VB, but not sure if it can be done through access. We have a system in place that was written in basic with a custom made ISA card in the PC which receives a signal from several switches, the program then works out what switch it was and updates a...

I'm desparatley trying to convince my company to buy a copy of visual basic, but even getting them to buy you a cup of coffee is difficult!!! Is it at all possible for MS Access to read a HEX address on an I/O card?

I have written a database which is used at a distribution centre for controlling trailer movements around site, as I am always looking at ways to improve what I can do with the database, the site is coming up to a very busy period and I have had an idea which would be very useful. There are...

greetings all I have created a form (continuous view) based on a query, each record contains a date field. If this time is more than 12 hours ago I wish to change the background colour of the fields. I have the code in the form load event which works fine but due to the form being a continuous...

similar Pat, there is one trailer park and there are 5 areas of 2 warehouses that change the status and positions of the trailers, there is also 1 point (which require this form) that monitor when trailers are in a certain state so that they can inform the drivers that trailer xxx is ready, go...

I currently have working within a small access db a form which contains an overview of a trailer park, which is a series of boxes containing dlookups which obtain the number of the trailer that is occupying that space, the background of these boxes also changes colour depending on the status of...

In some databases I have certain things blinking using the timer event, but I have a database with a form which is used 24/7 and displays the status of certain items, the timer event is set to refresh this information every minute. If an item is in a certain status I would like it to blink to...

I currently use the following code to obtain the week number based on my companies financial year Public Function FinancialYear(dDate As Date) As Integer FinancialYear = Year(dDate) - IIf(dDate < DateSerial(2003, 4, 27), 1, 0) End Function Public Function FinancialWeek(dDate As Date) As...

ta

greetings all I need to obtain the day number for a database I'm working on i.e. today is the 42nd day of this year, I do recall seeing something to get this, but I can't remember it now :/ any help would be appreciated

I have a databse which is used for logging information about deliveries. Each delivery is automatically given a booking time, after the delivery the user is required to enter an arrival time, if the driver arrives late, the user is then prompted to enter a reason why it was late. If the...

try Private Sub txtEmpid_DblClick(Cancel As Integer) Dim rs As Recordset Set rs = Forms!frmPager.RecordsetClone rs.FindFirst "pagerId = " & Me.txtPagerID Forms!frmPager.Bookmark = rs.Bookmark End Sub

you need to sign on as each user and use users and groups security part to create a password for them

I am using an Iif statement in a query but it is not prodicung the required results, can anyone see anything wrong? Iif([Forms]![Form]![Field]="A","A",Iif([Forms]![Form]![Field]="B",<>"A","P")) the first part works fine (="A"), the second part does not, although the <>"A" works when entered...

I have a make table query that works fine, but I need to upsize the database to SQL which requires a unique index field, I do not know how to create a unique index field using a make table query, can anyone help?

I have a combo box on a form using the following row source SELECT DISTINCTROW [tblVanOrders].[OrderID], [tblVanOrders].[OrderNumber] FROM [tblVanOrders]; OrderID is an autonumber field in the table and OrderNumber is a number field, the table contains 21745 records. The problem I'm having...

this site might help http://www.bizfonts.com/vba/

try strPassword = DLookup("[Password]", "tblEmployee", "[First_Name] = " & Forms!FormName!cboUserName)

I have a query that is set to delete info older than 'whatever'. the query is set to run whenever the form used to enter information is opened (with setwarnings = false)

Tools > Startup > Display Form