Search results

When I open one of my Accdb FEs, and open a query in design view, the context menu doesn't show "Sql View". If I shift double click the database, the "Sql View" is back again. I've removed all codes from Autoexec, OnLoad and OnOpen events of the first form that opens, still the moment that...

I'm studying the possible ways of adding an accdb (or accde) as a library to an existing database, opening a form that's located in the library, and returning the contents of a textbox on the form to the main database. Any kind of reading material, advice or sample database is much appreciated...

I have a single form with several subforms. There's no Parent/Child links between them. I need to click on one of the records of the subforms while the main form is dirty. If I click on the records I need, the main form's record get saved. If I add a Cancel=True in before update of the main...

I'm working on a product/order type of database and have trouble to setup the correct structure of tables and their relationships. Here is some rules that I have to follow: At present we have 44916 products and this number will grow in future. (Product1 - product2 - Product3 - .....) Tens or...

In Florida, as of January 1, 2025, children under 14 are barred from establishing social media accounts under a new law enacted by Governor Ron DeSantis. The legislation requires 14- and 15-year-olds to obtain parental consent to maintain accounts on social media platforms equipped with...

Can anyone explain in simple words what does this warning mean? I have a complicated query in Access that works fine and returns the expected results. If I copy its sql to a view in SSMS, I receive the above message when I try to save the view. Clicking OK bypasses the warning and the view...

According to the solution that was given by @MajP in this thread I use the following structure to access the methods or objects on a form; Dim frm as Form_MyFormName set frm = forms("YourFormName") With frm . ---> List of methods are included in intellisense End...

This question is an extended question to This post. Since the nature of the question is different, I preferred to start a new thread. When I use SMSS to login to sql server, I can see the sql server Logs under Management. ( I have 6 Files, archived included) If I add a login trigger to the...

Studying and learning Sql server. Environment : Windows domain with a sql server machine. The FE on all client PCs can access the data on sql server using DSNless linked tables. (Trusted_Connection) Anyone from a client PC, can install SQL server management studio (or something else) and...

I use the following to create a query from a csv file. SELECT ..... AS ....., ..... AS ....., ..... AS ..... FROM [TEXT;DATABASE=D:\test\;HDR=Yes].somefile.csv; How about if the file is Excel? Is it possible to query a table in a specific worksheet in an Excel file? If not...

Still in new year holidays and having nothing to do, I'm trying to understand what Mike Wolfe's trying to achieve in this article: https://nolongerset.com/a-safer-way-to-use-tempvars/ It seems that he adds a tempvar and then in the class, he sets a property to read the value of a tempvar and...

Not a suggestion but a question. When you’re on a touch panel (phone - tablet - touch screen) and you insert an image into a post, how do you drag and resize the image? Thanks

I need some confirmations on bellow case. I have an accdb database with 212 forms, 72 modules, 12 class modules & 51 reports. This database is used for developing and an accde is distributed for use. For the past few months I'd noticed that ALT+F11 takes around 20 seconds to open VBE...

I’m obsessed with crime documentaries. And America as a country with one of the highest rate of crimes, has always been a good seed for these documentaries. More than %99 percent of what you find in Netflix, Amazon, YouTube ,… is about some crime in US. I’ve always had a question but never had...

I've recently noticed some items have been duplicated in Intellisense. I narrowed down the problem and found out it's because of the following two references. Microsoft Scripting Runtime Windows Script Host Object Model Deleting any of them solves the problem. Because of the nature of our...

I have 3 linked tables to 3 csv files. These csv files are downloaded from an on-line order system. Because of some changes that our IT has put in place, I have to change the folder the csv files will be downloaded to. (From shared folder of domain controller to another File server). Is there...

Having nothing to do, I decided to run MZ-Tools' Review Quality on one of my databases. In Programming Rules Review, I'm receiving some weird errors I've never heard of. The number of parameters of a method cannot be greater than 5 (Receiving on API with more than 5 parameters) The number of...

A while ago, I saw a post from a member asking help for having a continuous sub form in continuous Main form. Since it's not actually possible, @MajP solved the problem by having multiple data sheet subforms. (If my memory serves me right) My search doesn't bring up anything. Does anybody...

I've never understood Tip culture in other countries. Not only we don't have it, we don't even understand why customers should tip someone who is being paid to do his/her job. Up to now, it was a mystery why tipping exists but I was just OK with it. Different cultures different methods And now...

This is a simplified version of a vbs script to create a mail Sub createOutlookEmail() Dim appOutlook Set appOutlook = Wscript.CreateObject("Outlook.Application") Set objMail = appOutlook.CreateItem(0) With objMail .To="Some mail address" .CC="Some mail address"...