Hi Gang. I am preparing a printout of music played at a record group and have the following group header for each composer: [Surname] & ", " & [Forenames] ...
Hi, gang. This should be rather simple. I have VB code in Access that opens an Excel file. I need the VB code that will close the file. What is happening,...
David The best way I think you can have your expression as page header is to make it a section header and set Repeat Section property to Yes. In the report...
I am having issues creating a subtotal in a form in Access. i've tried to use the dsum function that results in a #error. Here's fields in the form: Date of...
I'd still suggest you use DSum("DepositAmount","Deposits", "DepositDate = #" & [txtDepositDate] & "#") where DepositAmount and DepositDate are fields in ...
A form displays some data and also has two calendars, two frames, and two command buttons - all works fine when bouncing between draft and form mode. When...
Found the cause of the second form becoming partially frozen - the calendar as well as the frames (option group) of the second form are being 'blocked' from...
When I save the pdf file to a .txt file (plain), if I open that file with notepad I see a character like a vertical rectangle. I have tried to copy it and...
Has anybody ever had this bug : A query, which usually works fine, suddenly answers (approximately, translated from french) : "The query must have at least one...
Clauss Gilbert
gilbert.clauss@...
Aug 3, 2006 9:07 am
20236
I hope someone can help me. I have two tables (each one from a separate year); each has similar fields. I would like to take one field from table 1 and the...
Instead of SQL view go to design view. Are there any fields in the grid? If not drag them back down. You can go on forever trying to figure out how they were...
The grid has become empty ! My queries were quite complicated (with subqueries etc), not easy to rebuild by just draging field names. What is strange is that i...
Clauss Gilbert
gilbert.clauss@...
Aug 3, 2006 11:40 am
20239
The following program was written by "Bernie" and it worked beautifully until I replaced the sample data with data pulled from Access using MS Query. The...
It sounds to me that you may have deleted a table or query which was used to support these queries. Can you restore from a backup? Dawn Crosier "Education...
My table is an external table (an excel file). It might be that it was modified, or rather copied from another version for instance, so that "for a while", the...
Clauss Gilbert
gilbert.clauss@...
Aug 3, 2006 5:34 pm
20242
When you brought in the information from Access, did Excel give it a different data type? For instance, was your test data formatted with "General" and now...
Dawn - Thanks for replying. I looked at that and no. It doesn't seem to be a cell-level issue. I could type over the name of the county and it would work...
Try taking your Access data to Notepad and then from Notepad into Excel. It's possible that there are extra characters coming through which are not visible,...
Hello people, I was wondering which is the prefered data access method in access for a SQL Server backed. The front end is a MDB file with odbc link to the ...
I have three field in a form namely 1. item_id 2. item 3. hardware_id What i wanted to do was when i type an id in hardware_id which is equal to the...
A little clarification may give us some light into what you want to achieve. I assume you have two tables, Items and Hardware and that the form in question is...
already answered in the other group, please don't cross-post to many groups ... -- Brett Collings Strengthening Families Administrator D2D 46422 DDI (04) 916...
Hi all, I'm having a problem with my first split database. If more than one user tries to input data in records not necesarily being used by someone else, they...
Okay Keith your problem is that you're using record locking - true! If you read up about record-locking in Help it will explain that Access locks a "page" of...
Brett, My understanding is that Access 2000 and newer got the record locking fixed so that it only locks a single record. I know that 97 only allowed locking...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
