Search results for query: *

Hello all, I have a Word macro which converts a word document to pdf and copies it to a network folder. I would like to code VBA in Access which will go to a specific directory containing a bunch of Word documents and run the macro on each file before returning to the database. Can someone get...

This is drving me crazy and I've tried suggested solutions which don't seem to work. I have a simple query which includes LastName and FirstName fields. I can sort the query just fine for LastName then FirstName. I created a Report based on this query but it doesn't sort. I read that you're...

Hello all, I'm not sure if this is more of a MS Word Macro question or an Access database question but here it goes. I have documents in .doc format which need to be converted to .pdf for processing. I am able to write code in Access to grab the .doc files and convert them to .pdf but now...

Hello all, I have a table with client transaction information and a check box to mark whether it has been sent to a different department for processing. Once processed, the other department sends me a csv file with all the transactions it has processed successfully (some don't get processed due...

Hi folks, I have a query which I use to periodically export data to an Excel file. I use the <DoCmd.TransferText acExportDelim> command to do this. After I do the export, I would like to update the checkbox field in one of the tables so that it doesn't get exported again when I run the...

Here's a simplified version of my database: I have 2 tables: tblPersons (personID, LName, FName) tblWorkLoad (personID, WorkMonth, WorkType, WorkHours) I'd like to make a query which calculates the hours worked for each type of work for each person. For example, if the tables were populated as...

Here's a simplified version of what I'd like to do with a click of a button. I can't even begin coding it because I don't know if it's a VBA solution, SQL, or some combination. Plus my programming skills are very limited so forgive me for not giving it a solid attempt before asking for help...

Hello all, I'm trying to complete a project and need one last step. I have a folder containing a bunch of picture files, each of which require a corresponding index file (plain text) in order to be fed into the appropriate location of a separate database. The file names of the picture files...

Hello all, Just a shot in the dark here but is there a way to read a rtf file, extract just the first 5 lines of text (or the last 5 lines, whichever is easier) and save it as a txt file? For example, my rtf file begins with: INDEX FILE 0123456 28/02/2011 REPORT NAME FILE_NAME.RTF ..... ...

Hello all, I have a table with a field [SortOrder] as double. I use it to sort my form lists. Let's say I want to insert a record between [SortOrder] = 5 and [SortOrder] = 6. I currently just make the new [SortOrder] = 5.5 and it works fine but what if I want to insert another record between 5...

Hey there. I have a table populated with a bunch of dates. Can anyone suggest a simple way to find the closest historic (i.e. past) date to the current date? Thanks.

Arrgh, this should be easy but I can't figure it out. I have a tblMAIN with an autonumber MainID as the primary index. I've been using this field to sort my forms as it gives me the information in the order it was entered. However, I've decided to add a SortOrder field into my table so that I...

Hey there all, I have a problem and hope there's an easy solution. My main table has an autonumber primary index (MainID). I've been using this field to sort my reports because I want them to display in the order that they were entered. However, occasionally I want to insert a record in this...

Hello all, I have a report based on a query which filters for a specific employee and date range and displays all the shifts worked. The report looks something like this: Name WorkDate ShiftCode Hours John 2011-08-22 D 8 John 2011-08-23 E 12 John...

Hello, I have a database which is split into back and front ends. It works very fast when both parts are on a local machine but when I put the back end on a server, it slows down considerably. Any suggestions?

Unfortunately, my skills with recordsets are little to none.  I should make it a point to learn because I'm finding they are very powerful tools. That said, can anyone help me with my next (and last) step in this project? I now have a select query with results which look like this (I've...

I have a tabular form based on a select query which simply displays 7 names along with their corresponding SortOrder numbered 1-7. Something like this: SortOrder Name 1 John 2 Fred 3 Jane 4 Joe 5...

Hello all, I have tblPayroll with fields Name, WorkDate, Hours. I'd like to have a form in a spreadsheet type view with WorkDate as column headers and employees on the left as row names. Something like this: Jan1 Jan2 Jan3 Jan4 Jan5 Jan6 Jan7 John S. Jane D. Bob S. Then the...

Is there a way to call upon a make-table query and be able to enter the name of the table you want to create?

Hello all, I have a challenge that I'm hoping has an easy solution? I've created a work schedule table, from which I'd like to extract information to create a payroll list every two weeks. I also need to keep monthly stats with the information. The complicated part is that a night shift is...