Search results

Actually, Microsoft Office Accounting 2008 Express is more robust and also supports import of data from spreadsheets. The templates are provided by microsoft. Bob It is simple to set up and use. Give it a try.

It sounds like the sub-form is a continuous form, and the entry field is unbound. When an entry is made, it will cascade into all the records. You have to bind the Due field to a table.

Hi. I posted a "How to learn VB or Access" response in the string "Renumber a List". You might want to take a look. If you have Visual basic experience, you can use VB to import the csv to access. I use Access 2007, and the External Data (top) menu provides the capabilty to create a table...

Hi George, SQL 2000 t-sql reference to creating a partioned view (to allow updating) can be found here: http://technet.microsoft.com/en-us/library/aa258253(SQL.80).aspx I fully agree, you can break the massive table into logical pieces, but you may have to compromise some normalization due to...

Hi, I wrote a "How to learn to code a language like VB or use Access" response in the thread "Renumber a List". You might want to read that thread. Hopefully the advice is good. Smiles Bob

In general practice, the correct way logically, is usually the best way in code. Temp tables, and gimmick get arounds will just make things worse down the road, not that they do have have their place. The first place to start in learning a coding language such as Visual Basic is to: 1)...

Sorry I took your code and typed in what I thought would work. The code is missing 2 end if statement. One Immediately preceeding line 59 and another that should preceed the rs.close. This code example handles both adding a new record without needing a decimal point and deleting an existing...

Im a mainframer from way back, if you do the clip to the clipboard on the mainframe in a window's frame, it should work.

I have a form with a dozen popup subforms, which in turn have well over 30 popups within the subforms, and they can all be open at the same time. Only problem with that is ... form management when closing a subform, you may end up on a subform that you did not intend. You may want to include a...

Use keyword clipboard in Access 2007 help.

Use your Management Studio on SQl Server. My guess is everything is being pulled back to jet. You may have to use a pass-through or correct the new VBA code to ensure SQL Server can process the code on the server and pass back only the results. Another guess is that the new security function...

If it is soley a promotion, then that makes it simple. Exact matches on the address get removed. If it is an offer to a person for a credit card for example, then you are back to finding the criteria that satifies the institutions requirements (age, name, address all unique). You are on the...

Thanks for putting it in a code box Rookie. My comment is, since this is simply a query, then no data has changed and the requery is not required. May I suggest you single step through the code to confirm the if structure is flowing according to your combo box selections. If you put a stop...

George is right on, the process is extremely complex, but may be simple depending on the results that you need for your specific application.

To do a valid duplicate remove of names, you need 2 items, Postal Code/Zip code that norrows the possible duplicate to one city block and birth date to confirm duplicate person. Be carefull, my son is Dave Edward Harrison Brown, and I am Dave Edward Brown and we both live at the same address...

You actually only have 5 fields for the record. Your table definition should be: Month Short Integer Year Short Integer Ref1 Text Ref2 Text AmountArray Currency (occurs 12 times) The Literal months can be labels on a form and headings on a report. This should not be 12 records in my opinion...

Be carefull, if this date is used to read records from a table with a date format, but stored as text, you will not match any records, since date is always date/time no matter what format it is displayed. It is often defined as text instead of date to facilitate the sql search with "Where...

Gemma, I think BillBee has the indexed field Special set up as integer, and has duplicates to allow a decimal entry to place the record in the correct position. The decimal value gets stripped by Access, but Access slots it appropriately as the 2nd occurance. This gimmick works, but is a...

Question, are Tasks and Impacts Access 2007 multivalue fields? How are they defined in table Changes?

Fishing was great, got a couple nice Bass, one was over 2lbs. Made a great dinner today. I read your response to Gamma more carefully, just skimmed it earlier. May I suggest, you renumber first, then add the new record. For example, you want to add a new entry as #3, therefore, everything...