Search results

Copy specific worksheets from one workbook to another workbook, rename and save them to a given directory. '============================= With excel VBA you can just copy it to another workbook by recording a macro 1. First select all the sheets (you want) from one workbook 2. Right click...

is there any access VBA code to check if an workbook is open or not open ? In excel VBA - you could just loop through all the excel files that are open and you find the name of the file while you loop through and you could tell if that file is open. I couldn't do this in Access VBA.

I did union all to many queries but how do I order them as which ones goes in 1, 2, 3rd etc. ? It doesn't seem like the first query in the union all is the first one shown, and the second query in the union all is the second one shown and so on etc. How do I order it in a way that the first...

I am pretty new to access, so I don't know much of it's use and functions. But I am wondering does MS access VBA has the step into function that allow me to run the code step by step to see what it is doing and what value is storing in the variable so is easier to trouble shoot and manipulate...

If Discontinued Then Me!ProductName.BackColor = 255 End If discountinued is an option button and productname is a textbox. I use a code like this, and 255 is red. But when I checked to see for other color options, I see 255 is also yellow as per this website...

I have a table called BID with the following fields bidder, seller, iid, starttime, bidtime, and bidprice bidder is an id number that is reference to uid of table USER the USER table have the following fields, uid, uname, city, and state I created a BID form for the user to enter data into...

Hi, I wanted to create a field lookup with values that I specify, not on the table sheet, but on the form. User can click on a text box or combo box and can select a list of value that I specify, not values that are listed on a table but ones that I type in, in the form. Can this be done...

I have a AUCTION form, it has a combo box and the label for this combo box is called seller. This combo box is a look up to the USER table which has the following fields: uid, uname, city, state The combo box is pulling and displaying a drop down list of uname from the USER table, with this...

maybe is the time of a different region instead of the pacific eastern time?

Hi, I've created a form with a number of fields. One is a combo box, label as "Seller" and the second one is a text box, label as "Start_Time" and the third one is a text box, label as "End_time". I wanted to have a time stamp on the "Start_Time" field when the user selects a seller in...

Hi everyone, I created a form that allows users to enter data into the fields and populates the table. But can I have it do that and populate instead of one table, two tables? Thank you

SELECT timevalue([apt start time]), timevalue([apt finish time]), cint(format(timevalue([apt finish time]) - timevalue([apt start time]), "h")) as difference FROM Fixing where [apt start date] = [apt finish date] and cint(format(timevalue([apt finish time]) - timevalue([apt start time]), "h"))...

with two or more conditions and have compare time. For example, IIf ( ([max upload date]-[apt start date])>=1,"LATE" ) AS B, but also add another logic to the first if IIf ( ([max upload date]=[apt...

and find the max and min? How do you GROUP BY multiple fields and find the max and min of them? I did it and could only do it to one field, if I add more field I would have an error. Thanks, Appreciate it.