Search results

Hi Paul and CJ Many thanks for your replies. I understand that the access runtime version can import data from text and excel files but you have to program it yourself using VBA. Ueli

Hi Paul Thanks for your reply. Can the runtime version of access also import from excel or text files? If yes, then my issue is solved? If not, I was thinking of programming an interface using the DoCmd.TransferText Method or some equivalent. Is there an easier way? Ueli

Hi all I have created an access 2010 application for our cooking club. It is being used by all members, the majority of them with the runtime version of access. The DB updates, new recipes aso, are downloaded regularly from our homepage and thus are limited in size. I am therefore looking for...

Hi Dave I use the form to update a 'documentation record'. The record contains only three fields: date, title and file-name. All three are required fields. The form also has the following three buttons: a) save any changes made, b) discard any changes made (this is the mentioned abort button)...

Hi Bob and Dave Thanks for your quick replies. @Bob I will build a test db and do some isolated investigations. @Dave This is the change sequence: - Form is displayed with all data inserted. - I select the title field and cut data out with ctrl-x. - If I select the abort button the error message...

Hi Bob This is to check the required field has an entry: Private Sub txtDOtitel_BeforeUpdate(Cancel As Integer) If text_test(Me!txtDOtitel) <> 0 Then MsgBox "Im Feld 'Titel' muss etwas eingegeben werden!", vbInformation, "RCcompact" Cancel% = True End If End Sub This is...

Hi Access world To confess right away: I am an access/VBA beginner. So here is my challenge: I am testing field entries on a form using the BeforeUpdate event because I hate numerous error messages popping up when I finally want to save the record. This works fine up to the moment I...

Hello all, my name is Ueli and I live in Switzerland. I joined this forum as I have started taking my first access steps and naturally have stumbled over various roadblocks. I'm hoping to get some answers this way. Thanks in advance ;)