Search results for query: *

Brilliant.. so simple but I couldn't get it. Thanks!

It relates to being able to sync multiple handheld devices to the same table without collision. This is the solution, I just need to know how to implement it.

also, the table structure is FOO OID_A OID_B Name Age TIMESTAMP_A TIMESTAMP_B ----- ----- ---- --- ----------- -----------

I'd asked a technical support person for some help and they forward me the following text: In the desktop database, create two views (a.k.a. "queries"), FOO_A and FOO_B, both built on top of FOO. The FOO_A view (query) would have four fields: OID - derived from OID_A Name -...

brilliant, thank you jeff.

michael.. I'd already said the tables were IDENTICAL.. I found your response condescending and uncalled for.. I apologize if I've misinterpreted your tone.. thanks for your help dschomburg, mac.. I figured it would require a couple of SQL statements and I appreciate the confirmation.. :) a...

I've got a database of active patients with several tables. I want to be able to add a discharge function that automatically transfers discharged patient data to a new database and deletes data from the current database. This would include all data that matches the patient identifier. The...

I've got a database of active patients with several tables. I want to be able to add a discharge function that automatically transfers discharged patient data to a new database and deletes data from the current database. This would include all data that matches the patient identifier. The...

Thank you, very helpful. can I assume that anyone with access 2000 installed on their computer also has VB installed?

I don't wish to create an installation package via developer's edition.. Rather, I just want to copy my MDB to a different computer and allow it to be used. Access 2000 is installed on both computers. I tried this but first it won't let me edit the database on the other computer because of...

that's the ticket.. thanks.. by the way, now that you're here.. can you recommend any free rich text format controls? I was using the microsoft one but it doesn't allow print preview..

Because I'm concatenating in VBA based on a criteria search. It is necessary to do it this way.

I've tried both that and chr(9) and it displays the dreaded little box character rather than the expected tab.

The chr(13) & chr(10) has been a life saver for carriage returns, is there a similar method for using a tab in a string expression. I'm concanating two strings but the first string has variable length, but I'd still like the second string to match up in alignment. IE:

OK, solved my problem.. for any person interested or having a similar problem.. I created a variable dateconcate to sort user input into #mm/dd/yyyy# format, then compared it to my date variable 'uptime' dateconcate = Me.daytext & "/" & Me.monthtext & "/" & Me.yeartext...

Ok, sorry to ramble on but after doing some research it appears the because uptime is a date/time type that I'm having some problems. Data type mismatch in criteria expression.

criteria = "(DatePart('d','[uptime]')= " & Me.daytext & " And DatePart('m','[uptime]')= " & Me.monthtext & " And DatePart('yyyy','[uptime]')= " & Me.yeartext This is what I have and now at rst.FindFirst criteria I get a runtime error 3077 Missing ),], or Item...

Ok, I've tried using all suggestions and still no luck..

Paul, you're getting me one step closer although now I'm getting a data mismatch error.. Should the return of DatePart be an integer value? That's what I have set right now..

brilliant.. thanks michael..