Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.11 seconds.
Search: Posts Made By: RoyVidar
Forum: Modules & VBA 01-23-2008, 09:13 AM
Replies: 12
Views: 1,308
Posted By RoyVidar
> The implication being: If I don't ask, you...

> The implication being: If I don't ask, you won't tell why. That's a rather snooty attitute to take, I must say.

Snooty?

I tell you what I am. I am Norwegian. That is listed in my profile, and...
Forum: Modules & VBA 01-19-2008, 10:30 AM
Replies: 2
Views: 2,109
Posted By RoyVidar
I think perhaps one of the times Undo is...

I think perhaps one of the times Undo is available, is when the form is dirty - i e, it has unsaved changes.

You could try the following test/action in stead

If Me.Dirty then Me.Undo

But,...
Forum: General 01-19-2008, 04:18 AM
Replies: 11
Views: 940
Posted By RoyVidar
What about turning it the other way around, ...

What about turning it the other way around,

as long as people willingly do others homework and create whole solutions, is there any reason to expect better phrased questions showing evidence the...
Forum: Modules & VBA 01-19-2008, 03:38 AM
Replies: 12
Views: 1,626
Posted By RoyVidar
I agree, using the Range method of the sheet...

I agree, using the Range method of the sheet object makes more sense here, since that is instantiated and there's nothing else ensuring the correct sheet is used, making the Range method of the...
Forum: Modules & VBA 01-18-2008, 05:32 PM
Replies: 12
Views: 1,626
Posted By RoyVidar
The Excel Range is often used as this ...

The Excel Range is often used as this

Range("A1").Value = "something"

I e, as you do in formulas in Exel, start with the column, then row.

appXL.range("B" & lngStartRange).Value =...
Forum: Modules & VBA 01-18-2008, 09:21 AM
Replies: 12
Views: 1,308
Posted By RoyVidar
Using the CDbl function on a date/time, converts...

Using the CDbl function on a date/time, converts it to a numeric, where the integer part, represents the number of days since 12/31/1899, and the decimal part the hour of day, say 0.5 is noon.

>...
Forum: Modules & VBA 01-18-2008, 02:50 AM
Replies: 12
Views: 1,308
Posted By RoyVidar
Assigning CDbl(Now) for a date into a string...

Assigning CDbl(Now) for a date into a string passed to Jet will will barf several places in the world, including where I live. Allen Brownes formatting are safe, the same is ISO 8601 (yyyy-mm-dd...
Forum: Forms 01-18-2008, 02:39 AM
Replies: 6
Views: 2,586
Posted By RoyVidar
Ah, yes, sorry, actually, it should be enough to...

Ah, yes, sorry, actually, it should be enough to enter Tools | TheProject Properties... in the VBE, then change the project name there.
Forum: Forms 01-18-2008, 01:42 AM
Replies: 6
Views: 2,586
Posted By RoyVidar
Rename the database to something other than...

Rename the database to something other than createcontrol.
Forum: General 01-17-2008, 02:15 PM
Replies: 1
Views: 517
Posted By RoyVidar
Welcom to the forum. To delete a database,...

Welcom to the forum.

To delete a database, or change it's name, use Windows Explorer, and delete or rename the file.
Forum: Modules & VBA 01-17-2008, 01:51 PM
Replies: 2
Views: 1,035
Posted By RoyVidar
Why do you wish to empty variables? There is...

Why do you wish to empty variables?

There is really no point in doing so, unless you want to stuff something else into them.

The two first, are also meaningless. Assigning "" to a variable of...
Forum: Modules & VBA 01-17-2008, 01:39 PM
Replies: 12
Views: 1,308
Posted By RoyVidar
The error you're receiving, doesn't seem to come...

The error you're receiving, doesn't seem to come from the SQL statement you've posted.

One tip is to use the following after assigning the SQL string to a variable, but before executing it:
...
Forum: Modules & VBA 01-17-2008, 01:30 PM
Replies: 5
Views: 835
Posted By RoyVidar
Be careful with your declarations. Str is a...

Be careful with your declarations. Str is a function, and therefore shouldn't be used as variable name.

Dim TheControlName as string
Dim ctl as Access.Control
TheControlName = "lblMyLabel"
set...
Forum: Modules & VBA 01-11-2008, 10:55 AM
Replies: 4
Views: 45,333
Posted By RoyVidar
The reason why the original statement didn't work...

The reason why the original statement didn't work as expected, is that through the Format statement, you converted two valid dates to strings, then you compared those two strings (mm/dd/yyyy) ->...
Forum: General 01-09-2008, 03:26 AM
Replies: 6
Views: 1,015
Posted By RoyVidar
Sqlstr = "INSERT INTO ComputerName (ComputerName,...

Sqlstr = "INSERT INTO ComputerName (ComputerName, DateField, NumberField) " & _
"VALUES ('" & ComputerName & "', #" & _
Format(SomeDate, "yyyy-mm-dd") & "#, " & SomeNumber &...
Forum: General 01-09-2008, 03:16 AM
Replies: 6
Views: 1,015
Posted By RoyVidar
You're welcome!

You're welcome!
Forum: General 01-09-2008, 03:10 AM
Replies: 6
Views: 1,015
Posted By RoyVidar
TrySqlstr = "INSERT INTO ComputerName...

TrySqlstr = "INSERT INTO ComputerName (ComputerName) " & _
"VALUES ('" & ComputerName & "')"you need to concatenate it's value into the string.
Forum: General 01-08-2008, 02:45 PM
Replies: 5
Views: 1,019
Posted By RoyVidar
Where are you having these rounding problems? Is...

Where are you having these rounding problems? Is it in a table?

I'm guessing you have stored your numbers in a numeric field with the field size long integer or integer, which doesn't store any...
Forum: General 01-05-2008, 09:53 AM
Replies: 22
Views: 2,263
Posted By RoyVidar
In my second reply, demonstrated concatenation...

In my second reply, demonstrated concatenation with ADO with this:

SQLString = "SELECT TheDate, TheComment FROM TheTable WHERE PersonID = 42"
TheString =...
Forum: General 01-05-2008, 02:42 AM
Replies: 22
Views: 2,263
Posted By RoyVidar
> Without SendKeys I have no idea how to get the...

> Without SendKeys I have no idea how to get the contents of the memo field from several records into a single record/memo field.

Why would you do that? If you have it properly and relationally...
Forum: General 01-05-2008, 02:03 AM
Replies: 22
Views: 2,263
Posted By RoyVidar
Sendkeys has always has it's issues, and many...

Sendkeys has always has it's issues, and many developers recommend against it - sometimes focus has changed, and the keystrokes ends up somewhere else... I've read somewhere that Sendkeys with Access...
Forum: General 01-04-2008, 10:48 AM
Replies: 15
Views: 8,972
Posted By RoyVidar
Yeah, it did work on my a2k, but not on my a2k7 ;)

Yeah, it did work on my a2k, but not on my a2k7 ;)
Forum: Queries 01-04-2008, 10:05 AM
Replies: 7
Views: 787
Posted By RoyVidar
neileg is probably spot on - you're probably...

neileg is probably spot on - you're probably using a lookup field in your table, and experience one of the many reasons why many of us recommend against it.

See for instance...
Forum: General 01-04-2008, 09:58 AM
Replies: 15
Views: 8,972
Posted By RoyVidar
Some alternatives 1 - right click form title...

Some alternatives
1 - right click form title bar, select Close All (o2k7), or select design view, and then close
2 - hit ctrl+g, then type just quit, application.quit or docmd.close acform,...
Forum: Forms 01-04-2008, 02:01 AM
Replies: 2
Views: 536
Posted By RoyVidar
<smile>the division 1/1/2006 equals something...

<smile>the division 1/1/2006 equals something very small</smile>

Try with date delimiters

If Me.StartDate >= #1 /1/2006# Then

Seeing you're from UK, in the VBE Access is most interested in...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 05:51 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