Search results for query: *

I love pivot tables. I love the option where if you double click in one of the cells it drills down to show you records. My question is, how do I change the font size of the records you see from the drill down? I have a lot of data there, and I want to make it smaller so more fits on the...

I am importing an excel spreadsheet every month into one of my DBs. One of the fields can (but not always, and not even frequently) contain data with multiple values. These values are user IDs and are seperated by a semicolon. I need to analyze each of these IDs individually, but when I run...

Hi all. I have a long macro (running from excel) that runs every night running a variety of reports out of an access database for me. The last thing I want the database to do is to compact. I know there is a command line you can use with the /compact option, but I can't figure out how to run...

Hi all. I am looking to do the following: If AD2 = 0 then 'Fill row 2 with color(red)' Either the entire row or a selection of cells in that row, whichever is easier. I've googled like crazy, but I can't find this command. Thanks!

I have several rows hidden in a spreadsheet. I want to use the autofilter on the displayed data only, however wheneven I make a selection with the filter, it unhides all hidden rows. Is there anyway to keep the hidden rows hidden? Doing so in VBA would be ideal, but i'll take anything at this...

Hi all. I am using the following bit of code: Dim rngCalc As Range Set rngCalc = Range("AD2:AD" & Cells(Rows.Count,1).End(xlUp).Row) rngCalc.Formula = "=(8-K2)" rngCalc.Value = rngCalc.Value In this case, the first cell to be replaced is AD2 and it continues for as many rows as I have. What...

Hi there. Im new to using VBA in excel, so bear with me. I have a workshet with numerous rows. I need to make a snipet of code that checks a row, takes the values from a cell, runs it through a formula, and puts it in a cell at the end of a row. Once it is done, the have it do so for the next...

I need to update table1 with data from table2 using an update query. The problem is there is no field in table1 for me to update to. I want the query to create a new field in table1 so I then have a valid target to update the data too. Example: Table2 has a field named 'DataField' Create...

I have two tables. Each table shows a request # and another number field. Some, but not all, data between these two tables overlap in the request #. What I want my end result to be is one display as follows: Reqnum [Table1.Numfield] [Table2.Numfield] So, show me all request #'s from...

Ok, I have a query that subtracts two times and returns me a value. So in the query I have TotalTime: [Query1].[Time1]-[Query2].[Time2] However, there is not always a [Query2].[Time2] value. I have the query set up to show all records from Query1, but only those from Query2 which are equal...

Im not sure how to describe this, but here it goes. I have a query that returns numerous results for various jobs. Each job has an id, Job_Num. Everytime this job is modified, a new entry is put into the table, Job_History, so I can track the history of that job. So there are numerous results...

I have two dates and times, example 12/10/2005 1:29:22 PM and 1/6/2006 4:13:10 PM How can I have a query take these two dates and return the total number of minutes?

I have a query which returns a number of results, one of which a date/time field displaying mm/dd/yyyy hh:mm:ss AM/PM example, 12/22/2005 5:23:32 PM I want to make a query that knows what the current month is (but does not needs to show that in anyway), and shows me everything dated the previous...

I have a query which returns a number of results, one of which a date/time field displaying mm/dd/yyyy hh:mm:ss AM/PM example, 12/22/2005 5:23:32 PM How can I set criteria for this query to show all records from the current month only?

I have a few yes/no(true/false) fields in a form which are either visible or hidden based on other criteria in the database. I would like a vba script to do the following: return an integer (variable) of the total number of hidden fields that = true and then: Make all hidden fields = false...

I have a table with 40 or so yes/no fields (check boxes); a questionarre. I would like a query to return the total number of yes's it finds per record. I have it set up so only one record is queried at a time (as the query will be run from a form, and only the current record will be queried...

Ok, I have a variable declared as a string. The string is a line of text which is the name of a field on another open form. It changes based on the user's input on a drop down menu. Here's what I have: (the variable is decalred in a public area before this on click event): var = dlookup("my...

Hi. I have an inventory database, and I would like to create a button to import a small .jpg or .gif into the record. Thusly, whenever the record is called up, there is the visual record of the item. How can I do this? Thanx!

I am getting this error message everytime i try to compact and repair my database. However, no such table exists. I am even viewing hidden objects, but i still do not see it. Any thoughts?

I know I need to use the notinlist command and limit items to only in the list, but what is the event procedure to be used? For example, the table that stores is list is called OS, and the main table is simply called Main. thanx!