Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.05 seconds.
Search: Posts Made By: static
Forum: Forms 08-10-2018, 07:02 AM
Replies: 11
Views: 284
Posted By static
Re: Screen Design

You can move/size any form with VBA

Create a new form
Add
2 toggle buttons - tglSize and tglMove
1 list - lstForms
1 button - btnRefresh
1 textbox - txtMoveBy
Forum: Modules & VBA 05-30-2018, 02:47 PM
Replies: 24
Views: 800
Posted By static
Re: Access Control over another tab

Yeah. Silly way to go. But. I've enjoyed my time here. Hope I haven't upset anyone too much and helped a few...
Forum: Modules & VBA 05-30-2018, 02:19 PM
Replies: 24
Views: 800
Posted By static
Re: Access Control over another tab

No, I haven't lowered myself to your level yet. LOL It was a genuine question.

I can't say the problem is solved because I don't know what the problem was in the first place.

You have a problem...
Forum: Modules & VBA 05-30-2018, 10:23 AM
Replies: 24
Views: 800
Posted By static
Re: Access Control over another tab

What matter would that be?
Forum: Modules & VBA 05-30-2018, 10:04 AM
Replies: 24
Views: 800
Posted By static
Re: Access Control over another tab

I deleted the post because I got sick of your pedantry in the other thread.

You seem to be finding it funny. I just find it boring and slightly annoying.
Forum: Modules & VBA 05-30-2018, 07:55 AM
Replies: 24
Views: 800
Posted By static
Re: Access Control over another tab

A subform control can only contain one form. A form can contain multiple subform controls.
Forum: Forms 05-30-2018, 07:46 AM
Replies: 29
Views: 825
Posted By static
Re: Run time error 2450 when populating an array, help please.

Chr() and cstr() are two completely different things.

If you concatenate any non string datatype onto another string, or assign it to a string variable the value should be converted automatically...
Forum: Forms 05-30-2018, 06:31 AM
Replies: 29
Views: 825
Posted By static
Re: Run time error 2450 when populating an array, help please.

String & i will always result in the integer being changed to a string.
Forum: Modules & VBA 05-30-2018, 06:24 AM
Replies: 7
Views: 439
Posted By static
Re: Form OnCurrent event not firing - bug workaround

I just tested this and it's true, this doesn't work
DoCmd.SearchForRecord , "", acFirst, "[ID] = " & Str(Nz(Screen.ActiveControl, 0))

But this does
Me.Recordset.FindFirst "[ID] = " &...
Forum: Forms 05-30-2018, 06:17 AM
Replies: 29
Views: 825
Posted By static
Re: Run time error 2450 when populating an array, help please.

Access has great saving and loading functionality already built into forms.

Heed The_Doc_Man's words.

I had a go at cleaning your code. (Untested)

Public Sub Define_Arrays()

Dim...
Forum: General 05-29-2018, 01:19 AM
Replies: 39
Views: 4,698
Posted By static
Re: BackEnd getting corrupted since (I think) Win 10 updates

I get the feeling you're just being a troll so I'll leave you alone.

Let's hope the Windows update gets sorted.
Forum: Queries 05-29-2018, 12:53 AM
Replies: 25
Views: 921
Posted By static
Re: Export 2 queries to 1 csv (columns not the same)

It does feel like I'm speaking a different language at times. :)
Forum: General 05-29-2018, 12:47 AM
Replies: 39
Views: 4,698
Posted By static
Re: BackEnd getting corrupted since (I think) Win 10 updates

If the OP had been here to discuss database design I probably would have written something like that. ;)
But he wasn't so I didn't.

I have no idea who 'smiley coder' is. Probably you.
"I haven't...
Forum: General 05-28-2018, 11:53 PM
Replies: 39
Views: 4,698
Posted By static
Re: BackEnd getting corrupted since (I think) Win 10 updates

I've read that thread twice and don't see any disagreement at all. :confused:
Forum: General 05-28-2018, 11:07 PM
Replies: 39
Views: 4,698
Posted By static
Re: BackEnd getting corrupted since (I think) Win 10 updates

Memo fields have never been safe to use. I don't need to provide evidence because it's always been common knowledge and the post you linked doesn't argue otherwise.
Forum: Modules & VBA 05-28-2018, 02:21 PM
Replies: 24
Views: 800
Posted By static
Re: Access Control over another tab

Subforms can only contain one form. If you have 2 tabs that switch between Form1 and Form2, if you've set it to Form1 you can't refer to Form2.
Forum: Queries 05-28-2018, 01:49 PM
Replies: 25
Views: 921
Posted By static
Re: Export 2 queries to 1 csv (columns not the same)

You wouldn't be processing any records individually at all. That's the point. You would be BATCH processing.
Forum: General 05-28-2018, 01:46 PM
Replies: 39
Views: 4,698
Posted By static
Re: BackEnd getting corrupted since (I think) Win 10 updates

Not going to solve your problem but this is all I needed to hear.
The fact you haven't had issues before is amazing.
Anything that could impact your network performance could tip your Access...
Forum: General 05-25-2018, 02:13 PM
Replies: 39
Views: 4,698
Posted By static
Re: BackEnd getting corrupted since (I think) Win 10 updates

How many memo fields does the database have?
Forum: Queries 05-24-2018, 03:08 PM
Replies: 25
Views: 921
Posted By static
Re: Export 2 queries to 1 csv (columns not the same)

I don't disagree. As with everything to do with databases and VBA it depends on the number of records involved.

If the sample is representative then do as you like.

If lots of records are being...
Forum: Queries 05-24-2018, 01:38 PM
Replies: 25
Views: 921
Posted By static
Re: Export 2 queries to 1 csv (columns not the same)

Depends if the team members need to be listed under manager or not.

edit:

Imean if you were outputting multiple teams

manger1
teammember1
teammember2
manager2
Forum: Queries 05-24-2018, 01:31 PM
Replies: 25
Views: 921
Posted By static
Re: Export 2 queries to 1 csv (columns not the same)

I did a quick test

CurrentDb.QueryDefs("query1").SQL = "select 'foo' & chr(34) & chr(44) & chr(34) & 'bar' from table1"
DoCmd.TransferText acExportDelim, , "query1", "C:\Users\jon\Desktop\x.txt",...
Forum: Queries 05-24-2018, 12:50 PM
Replies: 25
Views: 921
Posted By static
Re: Export 2 queries to 1 csv (columns not the same)

Who are you responding to?

If I have a field with a value of

foo","bar

and Access outputs it to file as

"foo","bar"
Forum: General 05-24-2018, 12:41 PM
Replies: 35
Views: 14,058
Posted By static
Re: Filter data based on the User Login

I'm not in the camp that thinks a shared front end won't work AT ALL, but my solution won't work that way, so I'm out. ;)
Forum: General 05-24-2018, 06:03 AM
Replies: 35
Views: 14,058
Posted By static
Re: Filter data based on the User Login

NP NG. I deleted my post when I saw everyone talking about fields/controls and reposted again. Your solution may still be relevant anyway.
Showing results 1 to 25 of 500

 
Forum Jump



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