Search results for query: *

Not sure if I can make this work, or even if I can communicate exactly what it is that I need to do but here we go: I have a continuous form to list product details that a given user has access to modify. However, the query that I have won't let me update the couple fields I need to. I...

Hello all. Here's my problem: How can I use the following code in a continuous form? The result of this query gives me 288 records but when I use this as-is in my continuous form, I only get one record...the last one. dim db as DAO.Database dim rs as DAO.Recordset dim strSQL as string...

Hello all! I have a recordset that I need to populate into a continuous form. When I try the normal methods to set the textboxes equal to the recordset fields in the VBA I'm only getting the last record on the form, not the 200+ records that are in the recordset. I'm sure there is a line of...

The subject pretty much says it all. I have survey results in Excel that I need to merge into a Word document the contains several other pages of result analysis. I have SEVERAL of them and I will be doing this several times a month. I want to be able to copy all of the graphs from Excel...

I really hope this can be done. I have a continuous form listing projected quantities ordered by month over a period of time (user defined but usually 12 months). I want to allow users to modify some of the values but I want to lock others (i.e. dates that have already passed) but I have not...

PLEASE throw me a bone on this one... I have a table of "TimeClock" punches for employees. They are listed in the normal, horizontal record fashion by punch time & date: PUNCHINDEX, EMPID, TIMESTAMP, TIMEUSED (representing the time since the last punch) I need to display this...

I have a Crystal .rpt file that I am displaying through VB using the Crystal .ocx control. The report displays the saved report information fine but when I hit the refresh button I lose the data. The headings and other static objects are still in the report. When I open the report in the...

Hi all. I have recently been put in charge of a project to extract data from one (yes, we use more than one)of our old btrieve database systems. It's version 5x and the files are stored as DBF. I can do the extraction but I need the mapping of the fields. The consulting firm that designed...

My company runs a Weekly VB program that uploads a lot of information from our older, antiquated system into various mdb's for reporting purposes. Two if the mdb's are quite large prior to compacting. At last upload, one was 555mb and the other was a little over 400mb. Up until last week...

Well, the title pretty much says it all... I have to write up a program that will automatically run and export an Access query on a weekly basis. I have all of the programming necessary to initiate the timing automation but I can't seem to figure out how to control the Access mdb and export...

I have an reporting application in Access that produces charts, however, not all of the systems in my company are able to produce the graphs. They get an OLE error saying that the application is either not installd or not registers. Yet all of the necessary MSCHRT20 drivers are in place...

Thanks in advance. I have designed a reporting system that has 5 seperate reports that pull from the same query. So, to shorten the report run time I made that select query into an append query that updates a table. So, when the user clicks PREVIEW REPORT they are actually running a macro...

Is there a function in Access/Excel/VB that will convert a number value (i.e. 12,455) into a full string translation of that number (i.e. "Twelve-Thousand Four Hundred Fifty-Five"). If not, do you know of a site that can provide that conversion logic in VB editor code? I know this...

This is perhaps the silliest and frustrating thing that I have had to deal with in my history with Access. I am creating a report that compares one date range with the same date range of the previous year. Simple. The catch is that I have to sort the final report by the decending dollars...

I need some help. I have forms that are performing a lookup based on the text selected in a list box. The SQL statement uses "...WHERE ClientName = " & "'" & lstClient.Text & "'" This works for all occurences except if a ClientName has an apostrophe in the name...

I am trying to export an Access report out to Excel. I am using OLE to do this. It is moving along pretty smoothly except that I am getting an error - but not all of the time - over this section of code which is only intended to cut headers from one place to another...

I'm new to Pervasive and have to convert a btrieve .DBF to Access. My company has done this for years using existing DDFs that were created 3 programmers ago but now I have to convert a new table that does not have a DDF identity. How do you create a DDF to establish an ODBC link? Please...

I am trying to create a report linking several tables from one database (Maximizer 5.0). I have the 8 necessary tables linked in what would seem to be the appropriate way -using Left-Joins vs. Equal joins to give me the data needed if available for the client I am reporting on. However, I...