Search results

Hi I,m having trouble finding information/tutorials about dynamic arrays, the problem is that I'm trying to use a 2 dimensional array and having trouble getting it to work. Before I used 2 arrays, which worked well but now I'm trying to use a 2 dimensional one. It seems that the line of code...

Hi, What I am trying to do is have a array which will grow as needed. I have written some code but doesn't work. Dim cnn1 As ADODB.Connection Set cnn1 = CurrentProject.Connection Dim myRecordSet As New ADODB.Recordset myRecordSet.ActiveConnection = cnn1 Dim data5(1) As String Dim data5a(1) As...

Hi, What I'm trying to do is to change the value of the field within the record. The function will change the value of Username field within the secure table. By a sequence of input boxes I got a new username (newWord), which will replace the old one. I followed the book 'ACCESS VBA Programming...

Hi, Having one of those days, code won't work and nor does my office help. I quite new to this and having problem with my loop. name = Forms!orpheus.Type.Value If (type1(run)) <> name Then While type1(run) <> name tp1 = (sales1(run)) tp2 = (purchasing1(run)) tp3 = (firstFix1(run)) tp4 =...

Hi, What I have done is made a form which shows the user by a if statement: If([Type]="Orpheus 10x6x10",32,IIf([Type]="Orpheus 12x8x12",32,IIf([Type]="Orpheus 16x12x16",32,IIf([Type]="AGI 2x2x2 Modified",32,IIf([Type]="AGI 4x2x4",32,IIf([Type]="AGI 6x3x6",32,IIf([Type]="AGI...

Hi, I'm new to the vb code and having a problem with the form/vb, I've written a function that will check a password entered into the form against an array. It's a sinple form that has a password enter box, which is formatted to password in the properties a enter button and a cancel button. The...

Hi, I've had a long look around this forum and others and had no luck finding any help. What I need is a function to change the letters on the password input so that instead of the word typed by the user, there would be a line of dots or something to disguise the word. Has anybody done something...

Hi, I have a function that reads from 3 arrays, which works well but the problem is that everytime I have to make changes to the database I then have to alter the function writing the names into the function. Then I have to remake the MDE file, a bit of a b**** ache. So I was wondering how easy...

Hi, I'm new to vb and to make a function that will literate through an array. The array will have a list of names in it and when the function opens it will pen a input box asking afor a name, then it will literate through the array and return true if it's there or false if not. Please...

:Hi, At the moment I'm writing a production database for work, which include parts in/out, production planning, kitting lists and other forms. What I'm after is a way that when the database opens it asks for a password and depending what it is, is what you can do. Administrator can do all...

Well I've done it and it works except for one thing, it won,t autostart when I open the database. The cde is: Public Function fShowMsgAutoExec() Dim Pass_Word As String Dim sh As String Pass_Word = "jon" If Date >= DateSerial(2007, 1, 30) Then fShowMsg = MsgBox("This database needs maint, do...

Hi, I need to activate a message box on a certain date, I've tried the excel code: If Date <= DateSerial(2009, 1, 30) Then MsgBox("Hello") End If and I need to start it automatically, AutoExec but not sure how to do it.

-------------------------------------------------------------------------------- Hi, Just a quicky, How do I compare 2 strings? I've just started in VBA and not quite use to the syntax. Here's the code I've done so far and works up to the point where it compares strings. Public Function...

Hi, I need a password, which activates when it reaches a certain date is it possible. I've made a MDE file from the database and linked all the tables to original so can update. I use just wondering if it is possible?

If I make my database a MDE file, will it allow me to do maintenance? As I have a date query that removes records that are passed a curtain date and appends them to another table, which will be ok for this year but will need to modify the query next year. If the file is locked totally then I...

Hi, what I trying to do is let the database run for 6 months and then be password protected, giving me a chance to do the maintenance on it run queries, append tables and update formulars. I have set the spreadsheet to do the same. So I need a module to run on start up, compare the date and if...

Hi, I've just had some help with a spreadsheet security issue and I was wondering how to modify the code for Access? The code is: Private Sub Auto_Open1() Dim i As Integer Dim P_Word As String P_Word = "1968javajon" If Date <= DateSerial(2008, 8, 30) Then Application.ScreenUpdating =...