Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.27 seconds.
Search: Posts Made By: gemma-the-husky
Forum: Reports 04-18-2019, 01:57 PM
Replies: 13
Views: 250
Posted By gemma-the-husky
Re: Transfer first line of seqence to report

I think this sort of logic should output all the sequence heads.
I hope it helps you.

air code

dim lastrecord
dim newsequencemarker

lastrecord = ""
sequencemarker= ""
Forum: Queries 04-18-2019, 12:16 PM
Replies: 21
Views: 302
Posted By gemma-the-husky
Re: The Val function

val reads the number. From your examples, it must ignore leading minus signs.

note that there ARE a couple of alpha expressions that still get treated as numbers by val (eg leading e's will get...
Forum: Tables 04-18-2019, 03:46 AM
Replies: 12
Views: 379
Posted By gemma-the-husky
Re: Read constraint from table

@cronk

that makes sense. I hadn't checked - I am just used to handling DAO properties.
Forum: General 04-18-2019, 02:57 AM
Replies: 15
Views: 205
Posted By gemma-the-husky
Re: cdo woes

@gasman.

thanks for that. I saw a link to an image of that structure, but it wasn't interactive, so I couldn't expand the properties. I discovered I needed filename independently by reviewing the...
Forum: General 04-18-2019, 02:53 AM
Replies: 15
Views: 205
Posted By gemma-the-husky
Re: cdo woes

Eureka

I decided to create an outlook object, and see what properties that offered, and I then tried the same syntax for the cdo.message. The property/attribute I needed was FileName, which I...
Forum: General 04-18-2019, 02:30 AM
Replies: 15
Views: 205
Posted By gemma-the-husky
Re: cdo woes

@colin

I can see exactly what you are doing - I just want to try to go the other way.
I am not generating the email by inputting directly to fields. Instead, I am preparing a sales invoice, say ,...
Forum: General 04-18-2019, 01:38 AM
Replies: 15
Views: 205
Posted By gemma-the-husky
Re: cdo woes

@colin



I have a form that is trying to send an email in respect of some data entered. There are a few options to the mechanism to send the email. One is outlook, which works fine. Another is...
Forum: General 04-18-2019, 01:24 AM
Replies: 15
Views: 205
Posted By gemma-the-husky
Re: cdo woes

Hi. As far as I can see now, although you are adding an attachment, it doesn't actually seem to be stored in the cdo.message as an attachment. (see the link I referenced in #3 above)

I just don't...
Forum: General 04-17-2019, 02:50 PM
Replies: 15
Views: 205
Posted By gemma-the-husky
Re: cdo woes

@colin

It's going the other way that's my issue.

you have the code snippet

with message
If Len(aPath) > 0 Then .AddAttachment (aPath)

'so at this point is it possible to retrieve...
Forum: General 04-17-2019, 02:10 PM
Replies: 15
Views: 205
Posted By gemma-the-husky
Re: cdo woes

Hi colin.

I think I downloaded it earlier on. I will take a look.

However, I can send emails - but I just want to unwrap the cdomessage object to ask the user to confirm they want to send, or...
Forum: General 04-17-2019, 01:36 PM
Replies: 15
Views: 205
Posted By gemma-the-husky
cdo woes

Having spend a while on this, I can create and send an smtp message, and add atttachments.


A2016

For some reason I am unable to declare

set MyMessage as cdo.message
I tried to add...
Forum: Forms 04-17-2019, 07:19 AM
Replies: 15
Views: 231
Posted By gemma-the-husky
Re: Auto Increment

@OP

autonumber. You definitely do not want an autonumber. It's not guaranteed to maintain a sequence, and it won't deal with gaps. You need a managed sequence.


Nextnumber = (highest number in...
Forum: Forms 04-17-2019, 07:13 AM
Replies: 15
Views: 231
Posted By gemma-the-husky
Re: Auto Increment

Even if you store the prefix and item number separately, you may still have an issue

if you store these parts separately, then you can easily increment the part number.
(This also allows you to...
Forum: Modules & VBA 04-17-2019, 07:06 AM
Replies: 2
Views: 83
Posted By gemma-the-husky
Re: Customising Error 3022

Also, I saw this sort of construct the other day which seemed to do the job.
You may need to reset the error-handler at a suiaable point.

With rst
on error resume next
.AddNew
...
Forum: Modules & VBA 04-17-2019, 07:02 AM
Replies: 13
Views: 173
Posted By gemma-the-husky
Re: Error 3061 Too few parameters Expected1.

Am I right in thinking that this problem is caused by the resolution of the form reference. This bit.

((tblFileReq.ReqID)=[Forms]![NavigationForm]![txtID]))


I tend to get around this by...
Forum: Forms 04-17-2019, 06:59 AM
Replies: 14
Views: 177
Posted By gemma-the-husky
Re: Form field - want non-alphabetical display of lookup table values

If you only have a single column table, I can't see how you can get the records to sort in the order entered. Maybe you can, but I would have thought it would sort alphabetically. Without a...
Forum: Forms 04-17-2019, 06:56 AM
Replies: 4
Views: 95
Posted By gemma-the-husky
Re: Getting prompted for confirmation of changing record when record hasn't changed

If you set ANY bound field/control when the form opens/current event runs, it will make the record dirty.

Add record selectors, and you will see the triangle change to a pencil to indicate a...
Forum: Tables 04-17-2019, 06:53 AM
Replies: 15
Views: 265
Posted By gemma-the-husky
Re: Boolean as Null

@colin

I should have read down to the bottom of the link
I just assumed there was a way!
Forum: General 04-17-2019, 04:44 AM
Replies: 7
Views: 202
Posted By gemma-the-husky
Re: Mentorship

I think we all need both!

We are all adding a little knowledge every day. Some of us might not be looking for help as often as we used to, but we still have to look for it when we need it.
Forum: Tables 04-17-2019, 04:40 AM
Replies: 15
Views: 265
Posted By gemma-the-husky
Re: Boolean as Null

One of the options with a yes/no field is "triple-state".
I thought the third state would have to be a NULL, but have never bothered to investigate.

However, I have now, and it does appear to be...
Forum: General 04-14-2019, 08:49 AM
Replies: 7
Views: 177
Posted By gemma-the-husky
Re: ftp woes

Could be. I will report this possibility back to the system experts, as its getting outside my comfort zone.

ftp seems to be showing in the properties window as
GROUP: all application packages...
Forum: General 04-14-2019, 08:37 AM
Replies: 7
Views: 177
Posted By gemma-the-husky
Re: ftp woes

@TheDocMan

Can you tell me where the log gets stored.
I saw a reference to C:\windows\system32\logfiles, but I can't see anything there.
Forum: General 04-14-2019, 07:59 AM
Replies: 7
Views: 177
Posted By gemma-the-husky
Re: ftp woes

@sonic

If I go to the windows prompt, enter ftp, and then enter the commands manually, it all works. If I enter ftp -ns:scriptname directly at the windows prompt it works.

But if I try to...
Forum: General 04-14-2019, 02:56 AM
Replies: 7
Views: 177
Posted By gemma-the-husky
ftp woes

VBA code to run an ftp script is failing, but only on some computers.

The script logs in to an ftp site, does an ls to get a file listing, then does an mget * to collect the files

filename is...
Forum: Reports 04-13-2019, 02:23 PM
Replies: 13
Views: 250
Posted By gemma-the-husky
Re: Transfer first line of seqence to report

I think you need a temporary Y/N "Include" field in the table.

Then process the number sequence by iterating a recordset, and mark the ones you want with a "Y". You will process thousands of...
Showing results 1 to 25 of 500

 
Forum Jump



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