Recent content by highbulp

I know, I was wondering if there was a way to automate that instead of needing to go through the menus. But it's not a problem, I decided that using the menus wasn't that complicated for my users so just included that in the procedure.

Hey guys, I would like to be able to link a table from another database and then run some queries and stuff on it from a macro. I know that I will need to use the TransferDatabase action (with the Link type). The only issue is that I would like to be able to specify the to the database to link...

My solution was finally to make a temporary table and then count that. I had a form run a couple of queries to filter my main data table and populate a smaller, "report table." Since this report only had the records that I was interested in, I could easily take counts and other functions of...

I think I'll just set it up as a separate button. I don't believe that what your suggestion will do what I want. Thanks anyway for your response :)

This method allows me to add custom criteria for a particular field, correct? So that if someone enters '="New York" ' in the textbox, it will add a WHERE City="New York" to the query. Is that right? Is this the same for the second method (using LIKE), or does that create a pattern-matching...

That is exactly what I am doing. I didn't think I could have the actually criteria statement "field1<=condition" as an element of a form. But please explain, I'd really appreciate it!

Might it be easier to always run this process from a Form? Then you can have a form with the question, and you can have each button do whatever you want. //Newbie answering a question

I have a macro that I would like to open a Query in design view (so that the user may edit the query), and then run the query after the user has edited it (like when the user closes the design window). However, when I use the OpenQuery command to open the Query in design view, the macro just...

Well I've managed to get things working how I wanted. Thanks for all your help.

Unfortunately, we already have a survey import system set-up, and I don't think I can change that. The output it gives is a .csv of the specified format. I can import that into Access no problem, but now I'm having trouble accessing the data in the way that I want. So as I said, changing the...

I want a report that displays lots of different pieces of information from a rather large database. One of these pieces of information is a Count of the number of records which have a certain value in a certain field. I'm trying to get that number to display in the report, but I only want it to...

I'm sorry, maybe I wasn't clear. I already have the recordsource as a query that is tied to the form's controls. That's not a problem. The problem is, how do I reference the recordsource in a DCount call? EDIT: Okay, I think the problem is that my call...

Okay, total newbie to Access here. I've set up my database rather, now I'm trying to design rather specific reports. The report will only include data filtered by a form/query. I'd like to be able to do something like DCount("x",<THIS REPORT>,"x=1") but I don't know how to reference only the...

In other words, I need to have which question as an element of data in the table, rather than just implied through the table's structure? So I have to be able to check if that "5" applies to Q1 rather than checking that the "5" is in Column Q1. Is that right? It is also not feasible to change...

I have a set of evaluation response data. There are a number of question (like 20), and each respondent answered the question on a scale of 1 to 5. Thus I have a table Responses where each column is a question and each row is a Respondent's answers. Each cell has a value between 1 and 5...