Latest Bytes Forum

I have a Crosstab query that I am working on. So, for my Column Heading I want to use this 1 Field that has 5 options in it. Right now if I put in the Criteria "Car" or "Truck" I get 2 columns, 1 column for car and 1 column for truck. Is there a way I can just total those both up in 1 column. So the Field will show a total of Car & Truck instead...

1. Introduction ElasticJob, one of the sub-projects of the Apache ShardingSphere community, is a distributed scheduling solution oriented towards Internet applications and massive tasks. Since ElasticJob 3.0.1 was released, we’ve received a lot of feedback from users on GitHub. After merging the code committed by the contributors, ElasticJob...

This is such a simple basic thing I've done for decades yet now a problem? I'm sure it's something silly I'm missing. A search provides no answer for my situation. Library reference is to Microsoft Office 16.0 Access database engine object library. I removed that and changed it to DAO 3.6 library. Both compiled. Both gave me the same error. ...

I am using this vba code to prevent double entry: Private Sub BusinessName_AfterUpdate() Dim NewBusinessName As String Dim stlinkcriteria As String NewBusinessName = Me.BusinessName.Value stlinkcriteria = " = " & "'" & NewBusinessName & "'" If Me.BusinessName = DLookup("", "Sheet1", stlinkcriteria) Then MsgBox "" &...

Hey Forum! In my project there is a table containing archival data. This table currently has more than 3 million records covering a period of 11 years. Each month our team scans equipment for inventory. Unfortunately, many times during the month the same piece of equipment is inventoried multiple times. What I am looking to do is to delete...

How to split 123.4 in '1','2','3','.','4'

I have a table tbl_questions_answers with fields (correctAnswer and selectedAnswer). I want to compare the values of both fields in each record and make decision on it in access vba. I'm new to access and vba. Would appreciate if I can be assisted for vba code.

I have a table tbl_questions_answers with fields (correctAnswer and SelectedAnswer). I want to compare the values of both correctAnswer field and selectedAnswer field in each record and make decision on each. Don't know how to use For Each loop to loop and compare since am newbie in access vba. Would appreciate it if am assisted on vba code to...

Hello World! I’m newable in Perl but I really want and need to learn it. I’ve learned a lot but on my own, so I feel like I'm skipping information, and I don't know what I'm missing. Now I’m stuck, so I would be grateful if you kindly helped me with this. I’m trying to develop an approach to compare the degree of similarity of two input ...

I really need help and i would apreciate if someone can help me with this I need to do the same than here but with .NET, instead of node js. I never worked with .NET before. Is my first time working with tokens and APIs. So i kinda need help with this Question: Is it possible to do this with .NET? if it's not possible, i would like to know...

I have an Access database that I send out emails to our customers. When the command button is selected it opens Microsoft Office and generates the emails for me to send. We have now created a general email address (like info@abccompany.com) that is shared among my team. It is possible to change the from address in Outlook for the emails generated...

Hi Experts, I have a DataSheet form where I want to search my record using an Unbound Textbox. I have write AfterUpdate code for Textbox which is as under:- Private Sub txtSearch_AfterUpdate() Me.RecordSource = _ "SELECT * " & _ "FROM Students " & _ "WHERE (fncSearch(," & Chr(34) & Me.txtSearch & Chr(34) &...

I'm getting runtime Error 2487: The object Type argument for the action or method is blank or invalid It triggers at line 36 I have been using this code for awhile, but all of a sudden it stopped working. Can anyone see something I have wrong? Private Sub btnAuditEmail_Click() On Error GoTo Error

I have a form with several combo boxes, all with Limit to List on. If a user enters invalid data into one of them, of course he gets the "not in list" message. If he then decides he was on the wrong track and tries to cancel the form (Cancel button click event = Me.Undo), Access still keeps insisting on a valid entry in the combo box. I can't...

One major function of my database will be to print labels to be used for solicitation. Not all labels will be printed at the same time and I need a way to not repeat printing. I have little experience in VBA and I'm sure there is a better, quicker way to do what I've managed to do thus far. But I am stuck on how to finish this out. Database...

Hi All, I have a table NonReworkableparts with 2 fields of interest , Program Number and PartNo. On my form the idea is to select a program number from a combo box and when I type in a part number if it is in the table then it gives out a msgbox. There will be multiple part numbers, that's why I need to make sure I match against the...

Hello everyone! So today I will be asking some very important questions which many others might relate to. Your advice might influence my decision so its a request to answer this if you have reasonable amount of experience in the IT industry. My short intro: I am 26 year old. Completed my Bachelors in Cs with a cgpa 2.8/4 in July and now doing...

hi all i have database with linked burble sheet pic object all i want how i can detect this pic content to remark pic on to my data base like remark office and form scanner

We have a C# winform that uses the MVP design pattern for the user interface. For reasons I'd rather not explain we need to simulate a right mouse click on a specific control to deactivate the control. I found code that almost does what we need. private static extern void mouse_event( UInt32 dwFlags, // motion and...

I have a WordPress website that have affiliate products on Amazon. I want to integrate my website with Excel Sheet to get all my customers data those have visited my website, clicks on it and also purchased products from Amazon.

Probably everyone knows that ReactJS is a wonderful library for building web-applications. However, it doesn't look so easy to add some backend features to it. For example, how would you build in a contact form? In this post I'm going to cover some methods on how to do it simply. First of all, you cannot send emails with just React, you...

i cant figure out how to get when i have to find the all records in the mongo db document and check a field which is true or false from each document inside collection here i am first finding all user from user table after that taking the user ids and finding teir course registrations if the course registration is true then i have to increase...

Hi Actually i have a problem in my php sql ecommerce project that i am not able to change currency symbol $ to pkr and i tried to change it from php files and phpmyadmin but never find any solution .If someone can guide me ill be thankfull

I don't know why but i am getting an error showing "command-line error: missing source file name C/C++(593) '' Pls help me as I am new to it.

Hi, I am using the IBMDataServer Manager for monitoring queries. Indeed I only see the sql statements from package cache and stored procedures. For those which are used by triggers I cannot see, should I have to add any profile?