Why not have two listboxes one for name, one for URL, make the second listbox not visible. When they click on a row in the first, select the URL from the second.
your use of transactionid as a sort criteria will cause you problems since the transaction you add will have a transactionid out of sequence. I suggest you use date and time rather than just date that way you can select all transactions greater that the date/time of the inserted transaction.
Nobody has answered because you have not asked a specific technical question. The forum does not supply solutions but if you have written something that does not work someone will help you debug it.
if you are talking about ptr1 then it is destroyed when you exit fnCall2 and recreated the next time you enter the subroutine. You cannot rely on it retaining its value.
do
MonthUsage = InputBox("Please enter a monthly usage value")
if not isnumeric(MonthUsage) then msgbox "Please enter numbers only"
until isNumeric(MonthUsage)
MonthlyUsages(usages) += val(MonthUsage)
Looks like just the spot for a bit of recursion. create yourself a subroutine that creates the upper and lower case version of an ordinal position and then have it call itself until you reach the end of the string.
I think you should set your start up to Sub Main. Then write a main subroutine that displays your login form modally. When you have validated the user display your first form.
the windows function is returning a C string. These strings indicate the end of the string with a ASC 0. The instr is finding the end of the string and retassoc is then set to the string to the left of it.
Why do you have the details in a second table. It doesn't look like you need it, just move all the fields in the details table into the Customers table. If you wish to persist with the design you have then the insert into customers table at line 7 does not include the the Details_Id. YOu need to work out the ID of the record you have inserted into the Details table and include that in the INSERT into the Customers table.
oops, yes I missed that bit about the project name. I too prefer explicit joins laziness and too much time in the Oracle world must have overcome me. :-)
You may choose to have a separate frontend database on each users PC that all connect to database holding the data on the server. That way each user could have their own customised screen if that is what you want. It is a bit more problematic from a maintenance point of view but it is very simple to implement.
30 is pushing it a bit for MSAccess but in theory you should be OK. Just use one table and one form. Given the number of concurrent users I would be inclined not to use bound fields. Instead have a save button which builds an SQL INSERT statement to insert the row into the table. This way you are holding a lock on the table for the minimum time. This is important because Access is single threaded at points.
If you having concurrency problems you may like to consider migrating the data component to SQLServer Express (which is free) It is better at handling large numbers of concurrent users than Access
Dim contents As String
contents = ""
For Each c In Worksheets("Sheet2").Range("a1:a4").Cells
contents = contents & ", " & c.Value
Next c
TextBox1.Text = contents
the simplest way is to go to Tools -> Macro -> Record New Macro manually do what want, the macro will create the VBA for you, you can then go into the Visual Basic editor to look at, improve the code.
