twinnyfo
Last Activity: Sep 30 '24, 07:51 PM
Joined: Nov 16 '11
Location: Webster, KY
-
Delete lines 4-6 from my code it is unnecessary for this to work. -
twinnyfo replied to Want to create VBA to create a button which will go to the relevant line in a linked database for a clientin AccessTrue, true, NeoPa! Faulty assumption on my part, but hopefully the suggestion points OP in the right direction.
I should have learned my lessons by now—I’m just so accustomed to numerical values. Here’s the text version:
...Code:Dim strWhere As String strWhere = "[FinCoaching Enrollment File 2].Client_Name = '" & Me.Client_Name & "'" Call DoCmd.OpenForm( _
Leave a comment:
-
twinnyfo replied to Want to create VBA to create a button which will go to the relevant line in a linked database for a clientin AccessI would do this:
This assumes Client_Name (with only one underscore) is a Field in the referenced Table and a field available...Code:Dim strWhere As String strWhere = "[FinCoaching Enrollment File 2].Client_Name = " & Me.Client_Name Call DoCmd.OpenForm( _ FormName:="Clients with matches Full Report", _ View:=acFormsDS, _ WhereCondition:=strWhere)Leave a comment:
-
SC,
Also as a side note, concerning Report View (and layout View), I have all my reports default view set as "Print Preview" and I have the "Allow Report View" and "Allow Layout View" set to "No." This always ensures that when you are designing and testing your reports that "what you see is what you get." There can be some useful features of Layout View, but I prefer to make all my...Leave a comment:
-
enilc,
Welcome to Bytes!
First, in order for such code to work, it would need to be placed in the OnFormat Event of the Report's section that contains the sub-report.
However, a much more easier way to do this is to have the height of the subreport set to 0, and have the subreport's CanGrow property set to yes. Thus, when there are records, the subreport will expand to show them; when there are no records,...Last edited by twinnyfo; Apr 29 '21, 04:49 PM.Leave a comment:
-
Frank,
First, welcome to Bytes!
Second, instead of posting a link to an image, please upload an image using the "Advanced" button when you post something.
Third, I think I might kinda understand what you are talking about, but I am not quite sure. Let me see if this describes it properly: You have a form with a list box on it. When you first open the form, you want the list box to be empty, with...Leave a comment:
-
NeoPa,
The easy answer to the question as to why FileCopy won't work is that it doesn't work with files that are currently open/locked.
I am not smart enough to know why not, but, as you also agree and point out, fso.CopyFile does. Again, I can't explain why there is a difference, but there is. If the OP wants more than that, I cannot give it....Leave a comment:
-
Friends,
I accomplish this using a FileSystemObjec t as IslaDogs describes. It can force a copy, even if the file is in use. I have never experienced any issues.Leave a comment:
-
In general, you would need to use VBA to use the Table object and cycle through all the fields, assigning that list to the second combo box. The challenge is getting the list of fields into a recordset that is usable by the combo box. The only way I know how to do that is by using an ADODB recordset.
But, other than this advice, I am not going to build this for you when you have not put forth any effort to work through this yourself...Leave a comment:
-
NeoPa,
Ya know, I have been thinking about how one would accomplish this for weeks, then I decided to just submit a question--wrote out my thoughts and posted. Then I walked away for about 30 minutes and while I was away, I thought to myself, "Self, wouldn't one just declare a Public Sub in the Person Class Module?"
So, I came back and tried it, using my example, and it kind of worked, but I could not figure...Leave a comment:
-
Using a Class Module to Execute Code
Hello Friends,
'Tis me again, with what might possibly be a very simple question, but one I just don't know where to start searching. I will begin with an example that should make sense to everyone, then describe what I am trying to do.
First, a common example. Let us say we are working with an object. An object has properties, some of which can be changed, and it also has methods which do things. For example, a For... -
IslaDogs,
I did a poor job of properly delineating my antecedents. I fixed the spook-link. THAT has been fixed. That old age thing--we're still working on it.....
;-)Leave a comment:
-
@NoePa:
DUDE! Cover, totally blown! I meant to remove that before I posted it. Did someone say something about old age? That has been fixed.....
@SwissProgramme r:
Say what? If I could follow the first half of your post, I would probably agree with you--you appear much smarter than I. However, the bloat only occurs during the relink of an already compiled FE. Thus, I am not re-compiling, let alone re-re-re-compiling...Leave a comment:
-
A Compact and Repair on close did return the App to its original size, and I have great confidence that there will no be problems with this action.
However, because I trust NeoPa's years of experience, and because my FE is rather tiny, there is really neither harm nor risk in copying the FE everytime anyone uses it. In the grander scheme of things, this is probably the "best" way, and those who know me know that I would much...Last edited by twinnyfo; Mar 24 '21, 10:34 AM.Leave a comment:
-
I will try the compact on close method first. If not, I'll just copy the FE each time.
Thanks for the hepp!Leave a comment:
-
There are three MS Access .accdb files, and there are also several raw text and .tsv files. I wonder if it has to do with the re-linking of text files?
Just a guess.....
Either way, it "works," but it's still annoying.Leave a comment:
-
Joe,
Looks like you have some issues with periods and spaces (and a typo in the second SQL string). Also, I also recommend using variables for your SQL strings. This allows you to troubleshoot if you have to:
...Code:Dim strOrder As String Dim strSQL As String Dim dbs As Database strOrder = Me.TxtOrderNo MsgBox strOrder, vbOKOnly strSQL = _ "DELETE [DBA_inv_payment].*Last edited by twinnyfo; Mar 18 '21, 07:40 PM. Reason: realized variable was a string, so updated SQL.Leave a comment:
-
IslaDogs,
The bloat definitely occurs during the table re-link process. During that process, I watch the file size grow, then during the other processes it runs, file size is perfectly stable.
This is the only DB I have running table re-linking after it is compiled. For others, I relink to a permanent location, then compact and throw up to the network.
Just very strange.Leave a comment:
-
jspeta,
My apologies that your experience on Bytes was not up to your standards. I'm not going to sling hash, here, but it seems a little arrogant to become a member of a forum and on the same day, might I say politely, "insult" one of the moderators (and a very well-respected one, at that) who has 10,000 times more posts than you do. I don't give my loyalties easily, but once I do, I will defend those loyalties. NeoPa has...Leave a comment:
-
Access Front End Bloating?
(@niheel - I love the new UI!)
Friends,
I have a tiny little FE that manages some data updates that I receive from various places. Because anyone could use this FE from anywhere and access the files from anywhere, the FE needs to find the files, and then link the data tables to itself. All this work perfectly.
However, I have noticed that whenever the FE links the data tables, the FE itself (compiled as...
No activity results to display
Leave a comment: