Good Morning Aftab Ahmad
Depending on the version of Access you're talking about and at what level you've used the password - more than likely, you're out of luck.
We would need a lot more detail as to how your password is being used.
-Z
zmbd
Last Activity: Aug 8 '24, 03:26 AM
Joined: Mar 31 '12
Location: Nebraska
-
Our pleasure
If you run into a snag implementing this please feel free to post back to the thread
=ZLeave a comment:
-
There are several ways I can think of how to do what you're after using several methods, such as an extra field in the table, tempvars-collection, another table (or two), etc...
Would you need a record of when the batches were printed?
Would you need to know which labels were in each batch?
Would you need to know the last time a record's label was printed?
If no to all of the questions then I would use a tempvars...Last edited by zmbd; Oct 23 '22, 05:36 PM.Leave a comment:
-
zmbd replied to Match two fields in a table against a combo box selection and a text box entry / 2 fields on a form.in AccessMy two cents
Make it easy:
Two Cascading comboboxes (Link to tutorial) with the second control to either pull-up the part-number information by either drop-down selection, which would prevent one from even selecting a part that isn't part of the project, or by direct entry. If the part number lookup is done by direct entry, then use the NotInList event to popup a message to the user and reset the control.
...Leave a comment:
-
There is a combobox.notinl ist event that you should consider using to reset the control.
(https://learn.microsoft.com/en-us/of...obox.notinlist)
In certain circumstances I use this event in several of my front-ends to add new entries to the allowed list and in others I cancel the entry and reset it to blank.Last edited by zmbd; Oct 23 '22, 02:46 AM.Leave a comment:
-
Hello accessibilitysp
Welcome to Bytes.com - I moved your thread to the proper forum
Best of luck in your future endeavors.
.
-ZLeave a comment:
-
Hello ADezii
Remarkably similar to the code I have except I look for the SMTP address directly.
...Code:Option Compare Database Option Explicit Sub SendUsing_LateBindMethod_Click() 'Use following Dim statements for Late Binding 'NOTE: Additional Const declaration Const olMailItem As Long = 0 'For Late Binding Const olFolderInbox As Long = 6 'For Late BindingLeave a comment:
-
This doesn't sound like Microsoft Office or Microsoft Access based question
bibo1dd - please provide a lot more detail
If you have VBA script please post it by first clicking on the [CODE/] format in the ribbon and then posting the script between the [CODE] [/CODE] flagsLeave a comment:
-
the variable cnt should have your loop count, no?
However, you don't mention what you want to do with the value; thus, something simple likeconsole.log(cnt )should send the value to the consoleLeave a comment:
-
Good Morning Vladeta and welcome
What dev7060 is trying to say is that Bytes.com isn't a coding nor homework service, instead, the culture here is to help you to help yourself.
We'll proofread, we'll give pointers; however, complete solutions - not normally unless the solution is a really simple one-liner type.
So, with that in mind
We need two things from you:- What coding environment are you working in - we
Last edited by zmbd; Oct 22 '22, 01:15 AM.Leave a comment:
-
BarryA - please start a new thread for a new question
I can split post#3 into it's own thread if you would like...Leave a comment:
-
Good morning kjhyder;
Any progress on your end using the information I provided earlier?
Mind posting any progress you've made?
I do have my code:
1) You must have the desktop client installed. The code will not work with the cloud-based-outlook web-application.
Several of my remote labs have Outlook thru our company's Office365 tenant subscription; however, they do not have the desktop Outlook application...Leave a comment:
-
Sounds as if your headers are missing or damaged
Open a new project and then try compiling and running the following code as written:
...Code:// Bytes977919_CannotResolveSleep.cpp // #include <iostream> #include <Windows.h> int main() { std::cout << "Hello World!\n"; printf("starting to sleep...\n"); Sleep(5000); // sleepLast edited by zmbd; Oct 16 '22, 02:17 AM.Leave a comment:
-
Good morning kjhyder;
There is anobj.SendUsingAc countfunction - I've not used it myself in the Access environment; however, I have used it in the Outlook environment ( Microsoft Function: outlook.mailite m.sendusingacco unt ) I'm sure there's a way to use this in the Access VBA - might have to either late-bind or add the reference to the Microsoft Outlook object library.
I'll see if I can bodge something together in a little bit -...Last edited by zmbd; Oct 15 '22, 04:25 PM.Leave a comment:
-
Should be no code involved... perhaps more detail?.
MS-Excel Pie Chart TutorialLeave a comment:
-
@Buchert.
When you get your database lined out... please drop by - success stories make the best reading material!Leave a comment:
-
WerFault.exe is a windows error trap module. If you can find the text of the error log in the Windows Event Viewer that would be helpful.
I've a few personal matters to attend to right now; however, with your post of the actual error message we might figure something out
Also, please provide the names of the tools that you are using for your development - might need to use a different IDE, change a setting, etc..Last edited by zmbd; Jul 31 '22, 12:50 AM.Leave a comment:
-
Automate 20 Access DB Macros
🙋 Hello There yourself...
👍👍👊 I'm going to steal the table idea - I haven't tested this; however, nicely done. I have several DB that I've simply hard-coded into the VBA that run to update the databases; however, in my case I'm importing CSV files that we receive from various instruments into the database. I used to do some of this with batch/PowerShell files...Last edited by zmbd; Jul 31 '22, 12:23 AM. Reason: [z{stupid auto-spell check - time to disable that add-in!}]Leave a comment:
-
Hopefully this works for Hansy; however, if Hansey is dealing with a highly locked down PC the command line scripts and access to the scheduler are locked out by GPO-Sec.
I've had to find workarounds for all of my dot-BAT, dot-PS1 files, and all of my scheduled runs were removed by GPO and IT-Security refuses to allow an exception - drives me bonkers!...Leave a comment:
-
Hello Hansy,
Would you take a moment to clarify something for me:
Do you mean Access-Macros Or do you mean Access-VBA
These are very different beasties and call/implementing them are quite different.
The confusion comes from MSExcel calling VBA-Scripts "Macros;" however, MSAccess has two distinct programing environments, Macros and VBA scripts.
... another question comes to mind
...Last edited by zmbd; Jul 29 '22, 09:29 PM.Leave a comment:
No activity results to display
Leave a comment: