Search results

Greetings all. First, wasn't sure whether to post this here or under queries so I'm posting here so sorry in adavance if its the wrong area. Ok, that being said, here's my problem. In a application that I'm developing an Access 2010, I have created a query which has a column that calls a...

Hey all, Finally figured out the code for this and thought I'd post it, give back to the forum for all that I've gotten from it. This has worked really well for me and my documentation project and is certainly a big help, hope it is to you as well. If anyone has any questions, please feel...

In the case of the queries it generates over 100+ pages since it puts each query on a diff page (can't edit the report template) and gives me data I don't want. If I could get at the report template, I could do what I need.

Greetings all, I'm working on a large documentation project. I inherited several large Access db's (created in 2007, upscaled to 2010 prior to my inheriting them) and I need to print out each object and its associated description. I thought I could query one of the system tables to obtain...

LOL @ snow... were gettin our first taste tomorrow. Can ya say "day off"? Anyways guys, much thanks for your replies... I know the code is convoluted but this is what I inherited and just trying to make it work, which I can say, I have! I basically just got rid of the .edit portion and...

Greetings, I'm currently using .addnew and .edit methods to update a table in VBA. I have a flag setup so that if a new id comes in , then I use the .Addnew method to add a record to my table. Some of the records are update records, which need to have data pulled from certain fields, then...

try this Good morning Soppy, Try using this link. I've used it in the past and it has served me well.. very easy to implement. Common Dialog box

Hi LadyDi, I was looking for a thread that had to deal with this as I'm going thru the same exercise at the moment. What I have found is that unfortunatley you cannot export footer information. My assumption is that excel can only recognize so much. I've tried to put various info in my...

Update Well after fooling with the query and not getting anywhere I decided to remove the link to this table and re-link. Guess what? Query saved and did not chop off the leading 0's. I'm not even going to try and explain it cause it makes no sense, but I wanted to let you guys know that I...

Hey Guys, First, ty for the replies. Ruralguy: all fields are enclosed in []'s. I know the that the forward slash should be avoided at all costs but I've been told to name the fields this way so I'm stuck with having to oblige the boss in this case. Moniker: I should explain maybe that...

Append query and Leading 0's in field names Greetings all Came across a problem and wanted to see if anyone else has seen this or knows the cause. I am working in Access 2003. I have two tables stored in a backend. One table updates the other. The database I inherited was doing this via...

Greetings all, I have a report in which I need to change the groupheaders from section to section depending on what the value is on the top header. i.e. - Groupheader0 = 1. Groupheader1 = AA Groupheader0 = 2 Groupheader = BB Can this be done mid report? or...

couple ways to get around getting stiffed... I've been in this same situation on a couple of occasions over my years as an Access consultant. Here are a couple things that may help others in the future. 1. agree on a $$$ amount, then, set it up where you get 1/2 up front, other half upon...

Greetings folks, Started getting an error on friday that is not only baffling me, its baffling my helpdesk crew as well. I am using Access 2003. I had been getting the occasional MS Access exception error when attempting to save my database. Compact and repair usually fixed the problem but...

Greetings Bob, I was in the middle of changing my post and you probably replied while I was doing so. According to your post, it sounds like you thought that I meant linking to Excel as a table from Access. In actuality, its the reverse. The users would be inputting data into an excel form...

Greetings all, I have a client who initially hired me to convert an excel spreadsheet app to an Access app. Well they have now made a request (actually, more like a demand :mad: ) to use Excel as the input tool with the data being housed in access tables. I've never done this and was...

Bumping this up as I need to have this question answered as well.

Hi Russ, It turned out being that there were embedded carriage controls in my import file HTH, Tim

Hi Itchy, Shot in the dark here, but what version of office are you using? If its 2003, try changing your acSpreadsheetTypeExcel8 ref in the transferspreadsheet to acSpreadsheetTypeExcel9. I had an issue a while back with row counts in office2003 due to acSpreadsheetTypeExcel defaulting to...

hi Wan, If they upgraded your btree database, then they may have upgraded the drivers too, in which case you'll have to create a new ODBC connection. In Access , go to File, Get Extrernal data, then either Import or link tables option. When the popup windows displays, go to the "Files of...