Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 376
Search took 0.02 seconds.
Search: Posts Made By: Snowflake68
Forum: Modules & VBA 12-02-2019, 11:17 AM
Replies: 16
Views: 186
Posted By Snowflake68
Smile Re: Import CSV with Windows File Prompt

You are just brilliant, thank you. works like a dream
Forum: Modules & VBA 12-02-2019, 11:00 AM
Replies: 16
Views: 186
Posted By Snowflake68
Re: Import CSV with Windows File Prompt

thanks but I am not sure what you mean, where would I add these sorts of references. I just want to default the folder to point to for them to select the file from.
Forum: Modules & VBA 12-02-2019, 10:30 AM
Replies: 16
Views: 186
Posted By Snowflake68
Re: Import CSV with Windows File Prompt

Just one last thing, is there a way to code in the VBA to default the browse dialog to a specific folder?
Forum: Modules & VBA 12-02-2019, 10:20 AM
Replies: 16
Views: 186
Posted By Snowflake68
Thumbs up Re: Import CSV with Windows File Prompt

this did work after adding the library reference (as suggested by Gasman) but TheDBguy suggested a working alternative. thanks for you input though. This has taught me something new today.
Forum: Modules & VBA 12-02-2019, 10:17 AM
Replies: 16
Views: 186
Posted By Snowflake68
Talking Re: Import CSV with Windows File Prompt

thanks for this, works perfectly. Although I did have to add some further code to error trap when the user cancels out of the file Browse Filename dialog box. I just error trapper error code 2522 to...
Forum: Modules & VBA 12-02-2019, 09:34 AM
Replies: 16
Views: 186
Posted By Snowflake68
Import CSV with Windows File Prompt

I have the following code which imports a CSV file from a hard coded directory and filename (which is created dynamically) but I now need to change it so that the user receives a prompt to select the...
Forum: Modules & VBA 08-08-2019, 06:38 AM
Replies: 25
Views: 457
Posted By Snowflake68
Re: Cannot Open anymore databases

Thank you all so much for your input. I have a lot to read and digest here so I will come back to you once I am able to comment. Not sure what I will understand as I am no expert like you guys are.
...
Forum: Modules & VBA 08-07-2019, 05:50 AM
Replies: 25
Views: 457
Posted By Snowflake68
Re: Cannot Open anymore databases

I tried that originally but couldn't get it to work, i think its either because I have a parameter looking up a reference on another form to filter the results or because I am concatenating a multi...
Forum: Modules & VBA 08-07-2019, 01:40 AM
Replies: 25
Views: 457
Posted By Snowflake68
Re: Cannot Open anymore databases

I cannot make the concatenation query the record source of the form because I need to use a different query for that. But thanks anyway.
Forum: Modules & VBA 08-07-2019, 12:32 AM
Replies: 25
Views: 457
Posted By Snowflake68
Re: Cannot Open anymore databases

I just need to find out how to close them after they are no longer required. As I say I am no expert and still learning.
Forum: Modules & VBA 08-07-2019, 12:30 AM
Replies: 25
Views: 457
Posted By Snowflake68
Re: Cannot Open anymore databases

thanks for this. I have been using it this morning and it is very useful. I need to do some more testing using this but hopefully I will get to the bottom of the issue.
Forum: Modules & VBA 08-06-2019, 12:35 PM
Replies: 25
Views: 457
Posted By Snowflake68
Cannot Open anymore databases

I am using on of Allen Browne's functions (see below) to concatenate related records into a string. However I am occasionally and randomly getting an error 'Cannot open anymore databases' and the...
Forum: Forms 06-11-2019, 06:53 AM
Replies: 12
Views: 264
Posted By Snowflake68
Re: Sync Scrolling on two datasheets

If I could have worked out myself that I only needed 4 lines of code then I might have tried it. The sample application looked a little overwhelming to a novice like me to wasn't going to attempt it...
Forum: Forms 06-11-2019, 12:55 AM
Replies: 12
Views: 264
Posted By Snowflake68
Re: Sync Scrolling on two datasheets

Yes it is really a navigation form which yes I wish I didn't use but I am stuck with it now.

I wont bother with attempting synchronising the scroll bars now, the end user will just have to put up...
Forum: Forms 06-11-2019, 12:53 AM
Replies: 12
Views: 264
Posted By Snowflake68
Re: Sync Scrolling on two datasheets

This is how the end user has requested it so who am I to say otherwise. I gave them the option of how it could look and because their users are used to spreadsheets this is how they requested it.
Forum: Forms 06-10-2019, 06:57 AM
Replies: 12
Views: 264
Posted By Snowflake68
Re: Sync Scrolling on two datasheets

thanks for this. It all looks very complicated for a novice like me but I will try to figure out how it works to see if I can incorporate it into my application. It might be difficult as I have my...
Forum: Forms 06-10-2019, 12:53 AM
Replies: 12
Views: 264
Posted By Snowflake68
Sync Scrolling on two datasheets

I have two datasheets on a tabbed navigation form which I would like to synchronise horizontal scrolling. Not sure where to start or how to go about this or if its even possible.

Each form is...
Forum: Modules & VBA 05-03-2019, 03:19 AM
Replies: 6
Views: 133
Posted By Snowflake68
Re: VBA convert number to string but include trailing Zero

Right I have found a solution.

Set the table properties as Currency but declare the variable as a string but also format it as "0.00".

Thanks to everyone for their input, we got there in the...
Forum: Modules & VBA 05-03-2019, 03:15 AM
Replies: 6
Views: 133
Posted By Snowflake68
Re: VBA convert number to string but include trailing Zero

I have tried Currency both setting the table properties and declaring the variable as Currently and although it appears to store the value in the table OK it still only returns the variable without...
Forum: Modules & VBA 05-03-2019, 01:30 AM
Replies: 6
Views: 133
Posted By Snowflake68
VBA convert number to string but include trailing Zero

I have a csv file that I import into a table which contains costs of delivery. I import this table into my application on a regular basis as and when there is a cost change.

The table stores the...
Forum: Forms 02-28-2019, 09:55 AM
Replies: 18
Views: 234
Posted By Snowflake68
Re: Subform on Navigation form

Unfortunately it hasn't worked.
I tried the below and although I dont get any errors it does nothing to the Datasheet subform....
Forum: Forms 02-28-2019, 08:48 AM
Replies: 18
Views: 234
Posted By Snowflake68
Re: Subform on Navigation form

thanks but I still would need to know how to reference the datasheet subform from the DS subform in order to remove the source object from it and then put it back again.

Or do you mean from the DS...
Forum: Forms 02-28-2019, 08:41 AM
Replies: 18
Views: 234
Posted By Snowflake68
Re: Subform on Navigation form

I dont think I am going to be able to requery the Datasheet subform unless I know how to reference it which is what the my original problem was. When I click on the tab at the top that reloads the...
Forum: Forms 02-28-2019, 08:32 AM
Replies: 18
Views: 234
Posted By Snowflake68
Re: Subform on Navigation form

Ive invested too much time into the whole application to ditch it all now and dont really have the time to redesign it all. I am up against it tbh and need to get this working ASAP.:banghead:
...
Forum: Forms 02-28-2019, 08:11 AM
Replies: 18
Views: 234
Posted By Snowflake68
Re: Subform on Navigation form

How do I get the datasheet subform to reload within the DS subform?

I have code that hides and unhides columns but I cant get the changes to take affect unless I reload the whole form.

I have...
Showing results 1 to 25 of 376

 
Forum Jump



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