Search:

What you need to do is to Start a transaction.

Transaction is a process, in which all changes made since it was started can be either rolled back or comitted.

So that means:
1) Start...

Hi,

you need to first save the new master record -> in the master table.
Then you need to save the child records in the childs table.

That is because autoincrement field is not know until the...

I mean WOW!!! :thumb:

First of all


Very good... seems to get past the overflow error.
But still has a weakness... Format is I suppose region aware, and since the code will be running on a...

Yes... purely numbers.
The format is ###### but any of the # can be a letter.
There will not be any +/- or decimal separators.

It's not a key, but you can imagine it would be something like a...

Well well well... before I rate you :)
Here is a problem - Overflow error if the string is "12D308"
Apparently too big of a number.

Any idea?

B.

I just did check that...
Interesting workaround, but what is important, works (seems to be) like a charm...
And probably will be much faster than the loop.

Credit to both of you guys!

Thanks...

To: ganeshmoorthy
No, it seems that only letters D and E are recognized and both the same way -> they are considered to be the pover of the 10 -> so 11D101 or 11E101 is basically 1,1E+102 which is...

Hi all,

a quick one, but what a suprise.

I have a string - 6 characters.
I need to check whether it is a number or not. Simple so far... until I came to a discovery (not a word in VBA help...

I'm not sure about your WHERE example...
The function ISNUMERIC already returns TRUE or FALSE, so there is no need to test anything (you do not need to use <>... etc.)

But if you do, then you...

Use this in your SQL statement:

SELECT IsNumeric(Left$([YOURFIELD];1)) AS NumberFirst, .... FROM....


It will return you recordset, where first field "NumberFirst" will be TRUE if [YOURFIELD]...

hi everyone...

Excel macro... trying to insert formula into the cell using this code:

Range("G4").Formula = "=TEXT(D4;""0#"") & "" - "" & Output!B4"

The formula inserted should be this:...

Funny...
Not similar, but my colleague has reported that the newest excel (2003) does wierd stuff when undoing things:
1) It does undo the last operation - that's good :)
2) At the same times, it...

Hi,

so glad to see your name :)
The checkboxes were created by hand but let's consider they are created by the code, as this is the way it will be.

As for the db question - sure, I know and I...

Hey everyone.

I am hvaing problem in excel... I have a list of applications and checkboxes associated with them so the table looks something like this:
(see picture 1)

The checkbox (not from...

Hey everyone.

I am hvaing problem in excel... I have a list of applications and checkboxes associated with them so the table looks something like this:
(see picture 1)

The checkbox (not from...

ooops, here we go...

this is what I was afraid of :eek:

I have very little experience creating reports in VB and what's even worse, I do not have it installed now. So it will be kind of a...

Hey there...

I'm glad we've got it going... from what you gave me I suppose you are creating your report in "design" view and not in the wizzard, but maybe I am wrong... Anyway, I am going to give...

Just a quick reply (and not 100% correct maybe)

Data Control is an older type of control used with DAO connections. Data Bound Control is a new ADO control which makes use of all(?) the ADO...

ooops, I meant:
select the style...
:D

just making sure I don't fool you ;)

Cheers.

Hey there... u r welcome with the first problem ;)

For the other one I may dissapoint you as I never worked a lot with data report. But maybe I can take a look :)

As for your code, it works...

Ooops, sorry... my bad :bigyello:

I thought you were using listbox, not a list view...

Anyhow, this time I took a look at your DB and the problem lies elsewhere. The error you are receiving...

Doesn't make sense to me to be honest... :)

The recordset is OK as you wrote... what is the relation between the "[Price]/Vaulefromrecordset" and the recordset you are returning?

I suppose you...

Try using "ItemData" instead of "SelectedItem" property.

Brandon.

Well, couple of problems...


Your code that reffers to the listbox would return:
select * from FORMS where [ProjectID]= '1'
See the difference? Get rid of the ->'<-

But that is not all......

Hi.

Thanks for the explanation. I tried to design a very small database based on the information you gave me. Try to have a look at it. I will shortly describe it in here and the rest you can...

Haudi...
Sorry about that, I did not pay that much atention when I saw it changing :(

This time I took a little closer look (whole 5 minutes :blush: ) on your DB. Let's make sure that I...

OK...
Once again - I think the problem is in the design of your forms and subforms (seems like a mess to me, but maybe I'm just too blind to see).

Anyway, what I did was, that I opened your db...

Hey there.
I looked at your db and only change I made was in the code so now the AfterUpdate event now looks like this:


Private Sub List583_AfterUpdate()
' Find the record that matches the...

Hmm... strange. Well, at this point I am not going to install Acc97 :)

I can think of another way of doing it (how ugly though :sick: )

You could use a temporary table... link the second...

OK... here it goes and it works... :thumb:

First of all, I had to convert into Access 2002 format because I do not have 97 anymore. But that should make no difference.

STEP 1:
Change the "Row...

I must disagree....

Before I posted I just checked in Access and indeed there is AddItem.

Maybe we are on a different track, but what I did was I just created a new form, added unbound (!) list...

Of course it is possible to fill in the list box from a code.

all you need to do is loop through the selected items in ListA and then add them to ListB using:

form.ListB.AddItem "text"

Is...

Hmmm... interesting this one.

Isn't the excel naming convention using "!" instead of "$" ???
(Sheet1!A1:B10 instead of Sheet1$A1:B10)

"$" are used for fixing the cell coordinates... maybe you...

rs.FindFirst "[fname] = '" & Me![List583] & "'"

is that the problem? Without it you should be getting an error in SQL.

Hmmm... ok, I see your point. But I still don't understand why copying the two tables using SQL would not work for you?

Why are you converting fields from ADO to DAO types, if it is still the same...

Quotation from Access help:

If the MultiSelect property is set to Extended, requerying the list box clears any selections made by the user.

... does that help?

Brandon.

Glad it helped...

I am actually surprised a bit that you can do
.AddNew
followed by
.MoveLast

I thought the new record was held temporarily somewhere and then added. Well, if it works, so...

eghhh... I don't think you can do it that way...

BUT more reasonable to do is:

1) Use SELECT .... INTO [NewTable] FROM [Bunch of Tables]
>>> this way you create your new table
2) Now play...

I am not sure but it could be a case that ADO with Jet positions the current record on the newly added one... that is why it worked for you in first case.

Now, (it is case for DAO but maybe also...

Glad to help... you maybe should check out some of the tutorials on relating the tables (don't ask me where they are because I don't know :D )

Now I am sure that sooner or later you will come to a...