Search results for query: *

Ok...Looked around and haven't been able to find what I'm looking for on this, so hope you guys can help me out. I am trying to automate some of the tedious task within a report. I need to connect to a mysql server every day and create links to the newest tables in Access and then do an...

I have an Access Database that I need to stagger the two tables on output. Both tables have the same number of records, but different data and I need to show line 1 of table A, then on a new line I need to show line 1 from table B, then on a new line line 2 from table A and then on a new line...

I recently ran into an DLL issue and our IT department repaired Windows, as well as reinstalled Office Premium. Before this I had several reports that would run and send on they're own. Now since the Repair of Windows and reinstall of Office I am unable to run these processes and I get the...

Here's the scoop. I am trying to link to all files on a network drive..my strfile looks like this "strFile = Dir(strPa * th & "FileName*.csv")". My problem is the individual files were modified after they were stored and now the end of the file names look like this "filename... .csv120706.csv"...

Hey all. Need a little assistance here. I originally found this code online somewhere and someone here at my office helped me to modify it. However now I need another modification and the most knowledgable person here is out for the weekend. So I'm hoping you guys can help me out. The...

OK here's the scoop. I receive emails daily with attached spreadsheets for reporting of an outside vendor. I know how to create a link from Access to Outlook and store email information. However is there a way to do just that but also extract the attachments to a table/tables? Can that be...

I've got two tables with identical column names. I need to create a final doc that shows a list for the 1st column and totals the 2nd column. Some names in column 1 will be duplicated, but I only need them listed once and then totaled in the 2nd column. Here's an example of what I have and...

I am trying to find the max value of a non-standard field (ex. XAT-00000006719), however it doesn't seem to be cooperating. This is what I've got. VRF APR VRF-00000151740 XAT-00000006719 VRF-00000153895 XAT-00000006617 VRF-00000153895 XAT-00000007002...

I'm trying to build a query in design view that will display the lowest values of a specified field. When I say lowest I mean all but the top value. For example: Field 1 Field 2 123456 120 123456 150 123456 190 234567 130 234567 210 In this example I would only want to show the lowest...

OK...I hope I explain this clearly. I've built 4 queries to calculate different criteria. I need a 5th query to sum each up each of the sums on the prior 4 queries. The problem I'm having is if 1 of the 4 queries doesn't return a total (because there was no data) and the others do then the...

I am trying to link from Access to one particular folder in Outlook and pull the necessary data. However when I look at the linked table it only records 1 line of the contents field and I need 14 lines to evaluate these survey results. For example, the information being sent in the email looks...

I have table1/field1 with a date that is in the Date/Time format. Now I'm querying two different tables, one of these tables is set with Date/Time format (table2/field1), the other is setup with only a Text format (table3/field1). Querying table2/field1 is easy, however how do I change the...

First I have to say I do not know SQL or VB very well...so if I'm able to get this to work without learning a new language then I'll be ecstatic. OK...I have a tbl of approximately 1000 lines of data and about 20-30 columns each. The actual query itself is irrelevant, but I'm meshing this up...

OK...hopefully I can explain this clearly. I have two tables, we'll use Table 1 and Table 2. Each table has a date field, Date 1 and Date 2. Since I'm not experienced with Code, I would prefer to do this in an Expression. I need to find all records in [Table 2]![Date 2] field that comes...

I'm still farely new at coding in Access. So anything you could do to help would be grateful. I've got a simple form with a test box and a command button and two labels that are invisible. What I'm looking to do is this. When a user types a zip code in the text box and hits the command...

I'm trying to export a table out to more of a string that is used as a query within another program. Rather then taking all day to explain it let me post what I'm looking for. This is what I start with: 'Trouble Ticket ID:' = "TT-000000060457" OR 'Trouble Ticket ID:' =...