Search results

I've researched digital signatures, but no luck. I think it may a service pack 2 issue, b/c my laptop is unable to access the central desktop's database right after i upgraded to service pack 2. Before, I had service pack 1, and the central desktop (where the database is located) had service...

The macro security levels are already set at low at the moment. I think it may be a service pack 2 issue? At the moment my laptop can access and open the database (located on the central desktop's harddrive), but it will always prompt a message: "Do you want to open this file? Publisher...

I did that, but when I create a new record now NO numbers default in the field (ClientID) at all, and am getting an error. I think it has something to do w/ the "Randomize()" line as it shows as red in the code. --- Private Sub Form_BeforeUpdate(Cancel As Integer) Randomize () [ClientID] =...

Here's a few more details. I just upgraded to Windows Service Pack 2, and now when I access the central desktop's database (via my networked laptop), i get a message: When I click Ok, it will open as normal. However, when I have it open nobody else on the network can open the database...

I have the exact same problem...anybody know the answer??

I tried inputting Randomize() in the form properties in the BeforeUpdate; however, had the same problem. Whenever I try to add a record, it always starts with the same 6 digit number. Also, when I try to close the record, it has the message "Access can't find the Macro 'Randomize()'" I'm...

Thanks...let me rephrase a bit...right now I have in the "ClientID" field: Int((999999*Rnd())+100000) as Default Value in the table. I have this "ClientID" field in a form. When I open the form, it often changes the 6 digit numbers up a bit; however, a lot of times the number stays the...

I haven't used or am not sure where to add the "Randomize()" code. I've done a search and founds a few hints, i.e. inputting code like: Randomize RandomNumber = ..... Where do I add this?? I have no idea where the coding should go thanks again

In my client table, the primary key is the ClientID which is an autonumber. For the second field, it is set as a random number and default value is: Int((999999*Rnd())+100000) Not sure why I always get the error message stated above though...seems the database always defaults to the same...

I do not have any permission requirements or security levels set up right now, so am not sure why my partner cannot open the file whenever I have it opened. The funny thing is, when he has it open though, I can still open it (but it doesn't work when I have it open, and he tries to open it...

My access database is on one central desktop. When I go to the office, my laptop "connects" with this central desktop and uses the database. Also, my partner's laptop connects with this central desktop as well. For some reason, when I connect to the central desktop's database via my laptop...

My query contains two calculated fields [TaxSavings1] and [TaxSavings2], which are based on some currency and number-type fields in one of my underlying tables. I just created another field in my query which looks like: [TaxSavings1]+[TaxSavings2]. Instead of adding the two fields, it...

hey thanks, u guys are a lot of help. It adds now, which is great; however, although the "Amount" fields are all "currency" types, the expression produces just numbers withought the "$" sign.

Thanks, I tried that, and changed the "group by" in the ContactDate field to "Max"; however, when I run the query it still shows more than one contact date for each client (if the client has more than one contact date). I just need the query to show the most recent...and not the earlier...

I'm sure it's a simple fix, but I've been trying to figure it out for the last hour here... Basically, I'm creating an expression in a query that adds the numbers in 10 fields from a table to give the total. I.e.: Expression: [Amount1]+[Amount2]+[Amount3]...+[Amount10] The [Amount1]...

Sorry I'm a newbie... Do you mean I should create another query? And where do I put the term: "Max" ? Thanks again.

I am creating a query based on two tables: 1) tblClient (only one primary key "ClientID") and 2) tblContactDate (with two primary keys "ClientID" and "ContactDate"). Each client may have more than one contact date. In the query, I only want the records from the tblContactDate showing for the...

Worked perfectly, thanks so much! :)

I one of my tables, I have a date field (DateCompleted) with the format: mm/dd/yyyy Now, I want to create a query which would create another field (DateExpected) by using the date in the above table and adding 5 months to the date. The only issue is that for the new field in the query I want...

Sorry, I don't know how to do this. Can you help me? Thanks!