Search results for query: *

Maybe this is impossible? I have four tables of identical structure but not related. I am running a Select on four tables with three Union All. I would like the result from the Select and Unions (which work fine) to be routed into a Crosstab-type query to gvie the result from each table in...

With reference to thread779-631277 regarding problems with XP and multi-homing, I am wondering if this problem extends to having no traffic on LAN cards, i.e. no detectable network settings in Windows XP Home edition? I installed a Linksys wireless LAN card on a Dell Dimension, which already...

Based on ideas from thread705-760513 I developed a Union All sql query to extract data from four tables all with a common yearid field. I was able to know which table the data came from thanks to an idea from TonyJollans (Programmer) in the above thread to add a marker to each table. It works...

I have a client using a Brother MFC-890 printer. Whenever they print from Access the amounts on the report formatted for currency will not print or show, i.e. they are blank. (they show in the preview but not on the page). If I take away the currency formatting the amounts print fine as...

I have security concerns for a backend database. Though it requires user-level logon access, I would still need to disable Access menu items. I don't have any custom menu bars, but I would like to disable "Export" features and other database utilites from the curious. So far when I run this code...

I have a datetimestamp field of type Date/Time in a table, which is updated with the default value, Now() from the system clock when a record is created. I want to show in query and report when a record was created or entered. I have tried the following datediff statement to show entries that...

Dear Tek Tips I am getting error 3073 (operations must use an updateable query) when I run this code to insert into a table from another table. strsql = "Insert into tblchngecustomers Select * From customers WHERE customersID In (" & Criteria & ")" db.Execute strsql Criteria is a...

Can somebody help with this? I am trying to update a value on a form's combobox from an not in list event. I am making some error with the referencing of the control because this doesn't find the control Forms(frmname)!frmcmbtrl.Column(1).Value = strnewvalue I want to be able to pass the...

Dear Tek Tips, I have been reading some posts on distributing databases as MDE, MDB, Runtime, Comman Line Options, user profile's, etc. I am looking at the options to have the database as user friendly as possible with application specific menu items for forms, etc. But at the moment I would...

I am wondering what is the best way to go about filtering on a form. I have about three combo boxes that users might select from to filter the form in Datasheet view. However, I am never quite sure what the best way to go around this is. Should you? A) use the form's me.filter b) use a...

After exhaustive troubleshooting, I have traced the problem to the DAO. See thread181-557165 I had to convert this database back to 97 format to overcome a password problem, don't ask? It seems that in doing so there is confusion between ADO and DAO. I am now explicitly referencing DAO object...

I wonder could you help me out on a security issue. I have code which creates a query at run time depending on which table the user is searching. This query is created dynamically. The problem is that whatever permissions other than the default Admins Group permissions I set for the user, it...

I am wondering if somebody could tell me why this won't work. I have three queries with a field for totals in each table: in the queries below: qryweekly qryspecial qrycollections In a datasheet view form I am trying to show individual totals for each row (record), under headings...

I am wondering if somebody could help with an understanding on security issues. What is the correct procedure with security for a frontend pulling data from a backend databases? I know I have seen this discussed in other threads or a faq, I'd appreciate it if somebody could point me to...

I wonder if anyboyd could help me with using the Val function (to convert string to number) in an SQL Select statement as I need to sort on this. strsql = strsql & " ORDER BY " _ & "Val([People]" _ & "." _ & "[street...

In a table where there are three fields for address: Street No, Address0, Address1, I build a "full address" with the following string in a query for the form: FullAddress: IIf(Not IsNull([address1]),Trim([street no]) & " " & Trim([ADDRESS0]) & ", " &...

Dear Tek Tips I have three tables with Contributions. I would like to run a query for Year to Date on each one when the database is open and if the total from the three exceeds $250 then to remind the user that these people have to be contacted? I am thinking of a pop-up-window. Any ideas...

I have a situation where I keep getting a syntax error for a Select statement. My questions is. Can I use select in VBA Code with a query I have already built for two related tables or should I start from scratch using the join? Here is the code copied from the SQL View of the Query...

I am trying to produce stats. Unfortunately, for this the year does not begin as a calendar year, it begins on the first Sunday of March (ends on the last Sunday of February). Can anybody advice me how to calcalate totals for YTD dynamically for any given year? Much Appreciated! Regards John

<Index name> isn't an index in this table. Look in the Indexes collection of the TableDef object to determine the valid index names. (Error 3015) This error message has come up causing the database not to open. How can I repair the error, or is there some root cause? Appreciate your help! John