Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 34
Search took 0.11 seconds.
Search: Posts Made By: navi95
Forum: Forms 03-15-2017, 01:55 AM
Replies: 8
Views: 1,039
Posted By Minty
Re: Opening Specific Record from a List

I would have a read here for a sensible solution http://baldyweb.com/wherecondition.htm
Forum: Modules & VBA 12-11-2016, 06:37 PM
Replies: 18
Views: 555
Posted By missinglinq
Re: Empty Field Check

FYI, the reasoning behind Galaxiom suggestion is that an 'empty' Control/Field, in Access, is usually Null, not a Zero-Length String ("") which is what your code is checking for.

A Zero-Length...
Forum: Modules & VBA 12-11-2016, 03:48 PM
Replies: 18
Views: 555
Posted By bob fitz
Re: Empty Field Check

Sorry folks. That's what becomes of trying to do this and hold a conversation with my wife at the same time. Thanks to Galaxiom for the correction.
Forum: Modules & VBA 12-11-2016, 03:39 PM
Replies: 18
Views: 555
Posted By Galaxiom
Re: Empty Field Check

I sure Bob knows that expression will always return False since the Equals operator cannot compare with a Null.

This one is pretty common.

If Len([telefonnummer] & vbNullString) = 0 Then
Forum: Modules & VBA 12-11-2016, 03:22 PM
Replies: 18
Views: 555
Posted By bob fitz
Re: Empty Field Check

Try the forms Before Update event for validation.
Maybe: if [telefonnummer] = Null then
Forum: General 12-06-2016, 02:36 AM
Replies: 5
Views: 532
Posted By CJ_London
Re: Recovering Deleted Records

once a record is deleted, it's gone and cannot be recovered. Standard practice is to never delete a record except those that are 'wrong' in some way. Instead have a 'Deleted' flag field the users can...
Forum: Modules & VBA 12-06-2016, 01:55 AM
Replies: 3
Views: 303
Posted By Minty
Re: Running VBA code through Macro

I think Import is probably not a good name to use for a function, as it is a reserved word.

Try calling it OpenImport or something similar.
Forum: Modules & VBA 12-06-2016, 01:08 AM
Replies: 3
Views: 2,368
Posted By Ranman256
Re: VBA run-time error 3170: Could not find installable ISAM

Also, Kunden must be in quotes. "Kunden"

You can install the isams via control panel, programs,Access repair/reinstall.
Make sure you check all. ODBC drivers,isams ,etc
Forum: Modules & VBA 12-04-2016, 08:30 PM
Replies: 10
Views: 574
Posted By pbaldy
Re: Cancelling InputBox procedure - Part 2

Doc, I don't see that your code would get into the error trap. In my experience, and in a brief test just done, hitting Cancel or the "X" returns a ZLS. The test just done:

Dim strAnswer As...
Forum: Modules & VBA 12-04-2016, 08:13 PM
Replies: 10
Views: 574
Posted By The_Doc_Man
Re: Cancelling InputBox procedure - Part 2

Paul, I went through the gyrations because of the claim of getting a error trap firing when he cancels the input box without answering. The claim occurs in the other thread to which Dave refers.
Forum: Modules & VBA 12-04-2016, 10:15 AM
Replies: 10
Views: 574
Posted By gemma-the-husky
Re: Cancelling InputBox procedure - Part 2

OP. Why this thread, as you asked the same question on the first thread?
Forum: Modules & VBA 12-04-2016, 09:32 AM
Replies: 10
Views: 574
Posted By pbaldy
Re: Cancelling InputBox procedure - Part 2

I simply test for an empty string, which is what hitting cancel returns if I remember correctly.
Forum: Modules & VBA 12-04-2016, 06:51 AM
Replies: 10
Views: 574
Posted By The_Doc_Man
Re: Cancelling InputBox procedure - Part 2

First, be aware that StrPtr is an "undocumented" feature normally used to deal with passing strings from VBA code to compiled code in other languages (and passing them back, too). There are other...
Forum: Modules & VBA 12-04-2016, 06:21 AM
Replies: 10
Views: 574
Posted By Gasman
Re: Cancelling InputBox procedure - Part 2

Private Sub Umschaltfläche13_Click()
Dim strInput As String
strInput = InputBox("Bestellnummer Eingeben")
If StrPtr(strInput) > 0 Then
TempVars.Add "bestnr", strInput
DoCmd.OpenReport...
Forum: Modules & VBA 12-03-2016, 07:48 AM
Replies: 7
Views: 424
Posted By gemma-the-husky
Re: Cancelling InputBox procedure

I presume something like this


dim entered as string

entered = InputBox("Bestellnummer Eingeben")
if entered<>"" then
TempVars.Add "bestnr", entered
docmd.OpenForm "retour"...
Forum: Modules & VBA 12-03-2016, 05:44 AM
Replies: 7
Views: 424
Posted By The_Doc_Man
Re: Cancelling InputBox procedure

Understand that when you cancel an Input box, you are supplying a null answer to the question and will have to handle TWO conditions: First, an abnormal program event; and second, an abnormal answer...
Forum: Modules & VBA 12-03-2016, 04:43 AM
Replies: 7
Views: 424
Posted By JHB
Re: Cancelling InputBox procedure

As I wrote before I can't reproduce that error.
Try it in the attached database.
Forum: Modules & VBA 12-03-2016, 03:25 AM
Replies: 7
Views: 424
Posted By JHB
Re: Cancelling InputBox procedure

I can't reproduce that error.
Try to create a new form and put in the same code behind a button, do you still get the same error, if yes post a sample database, with the form in it.
Forum: Forms 11-26-2016, 11:50 AM
Replies: 3
Views: 459
Posted By MarkK
FWIW, I would be tempted to do this math in the...

FWIW, I would be tempted to do this math in the query that drives the form rather than in the form itself.
Forum: Forms 11-26-2016, 11:32 AM
Replies: 3
Views: 459
Posted By sneuberg
Re: Calculation not working

What do you see if you just put

=[Anzahl]

in Text14?
Forum: Queries 11-26-2016, 06:58 AM
Replies: 8
Views: 931
Posted By stopher
Re: Query based on Many to Many Relationship

Ah, so you want to summarise the data and not show the details? So you should google aggregate queries. They are dead easy to do.
Forum: Queries 11-26-2016, 06:39 AM
Replies: 8
Views: 931
Posted By plog
Re: Query based on Many to Many Relationship

Please demonstrate your issue with data. Provide 2 sets:

A. Starting data from your table(s). Include table and field names and enough data to cover all cases.

B. Expected results of A. Show...
Forum: Queries 11-26-2016, 06:36 AM
Replies: 8
Views: 931
Posted By stopher
Re: Query based on Many to Many Relationship

If you want to display on screen then use a form. If you want to output the use a report. Both tools are designed to group and total as you request.
Forum: Forms 11-25-2016, 08:07 AM
Replies: 9
Views: 490
Posted By RuralGuy
Re: Ordering System, Form with Subform

That's great! As you know, there many ways to skin a cat. :D
Forum: Forms 11-24-2016, 10:54 AM
Replies: 9
Views: 490
Posted By CJ_London
Re: Ordering System, Form with Subform

thread moved to forms - sample databases section is for the posting of samples for use by others
Showing results 1 to 25 of 34

 
Forum Jump



All times are GMT -8. The time now is 05:02 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World