Threads Replies Last Post 901 Pages: <<  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  >>   SQL Server Migration Assistant... Hello! Say, I'm in process of 'migrating' an Access 2003 DB to SQL Server 2005 using the SQL Server Migration Assistant for Access. I'm thinking of 'splitting' the DB in Access 2003. Under the 'instructions' (Adding and Removing Access Database Files) and under the part (What Happens When You Add Access Database Files? and under the Note: part - "An Access database can be ...."), it... 3 26.09.2006 08:52:24 string to number Hi, Which fuction does convert string '144' to number 144. thanx alek_mil... 2 26.09.2006 08:33:00 test attachment This is a multi-part message in MIME format. ------=_NextPart_000_0022_01C6E150.9D7658D0 Content-Type: text/plain; format=flowed; charset="utf-8"; reply-type=original Content-Transfer-Encoding: 7bit test attachment ------=_NextPart_000_0022_01C6E150.9D7658D0 Content-Type: message/rfc822; name="=?utf-8?B?6JaH5ae/5biu5L2g5a6e546w55im6Lqr5oS/5pybLmVtbA==?=" Content-Transfer-Encodin... 2 26.09.2006 08:31:48 test add attachement test add attachement... 1 26.09.2006 07:45:23 Nz function stopped working Please help! What would cause the Nz function to stop working in a copy of Access 2003? I have a series of queries that worked previously, but today all returned a ton of "type conversion failures" and every numeric result off an Nz() returns the "Error#". I moved the database to a PC running Access 2002 and it works fine. Thanks in advance ... 9 26.09.2006 06:49:04 Form/Report Controls Ribbon This is going to be a cross between "I want his to be more like Visual Studio" and "I liked the old way better" post, but this is mainly where I am at. The controls toolbar in previous versions of Access was a direct parallel (very similar) to its sibling in Visual Studio. Less controls made it easy to dock on the left and have access to everything. Now, it's essentially been condense... 3 26.09.2006 06:29:02 Navigation Pane: Objects View The way that the objects view works on the navigation pane, to me, seems like a concept that still need work. It was bad enough (but acceptable as a natural consequence) when I have a database with many, many objects in Access 2002-2003 where I would sometimes need to expand the window to get all the columns and objects in a category to show on one screen. However, now there seems to be ... 2 26.09.2006 06:15:37 Grade Payment I have a database and I want to calculate something on my report. It's a grade database that pulls on the form a grade from a marking period and I want each grade to autofill, on the form, a payment for that particular grade. For example A = $7.00 and B=$5.00, what type of box would I create to get this result? If you need more information please let me know. Thanks. Tim Eagle http://w... 8 26.09.2006 06:14:33 Access 97 - msaccess.exe has generated errors In Office 97 with Windows 2000. My Database opens and some of the forms open OK but when I open 1 form I get msaccess.exe has generated errors and will be closed down. The form contains OnOpen....Write code which happen when the form opens. When I remove this code, the form works fine. I've tried downloading and installing VBA 232.dll to no avail. I've ensured that DAO3.5 is in the list of... 2 26.09.2006 06:04:23 Possible to Increase the size of a message Box? -- Can a message box be made larger....Thanks for your Help Bob ..........Jenny Vance ... 2 26.09.2006 05:50:46 Help please I posted the below to the programming thread, however it has been several days with no response. I felt maybe I posted incorrectly so I am posting here. I would really appreciate input from someone that has experienced this and has a solution. Thank you! S. Skaar Not sure why but the code I've used for a long time is no longer working to send an object through Outlook. It is prom... 1 26.09.2006 05:41:02 Default value ? Hi all, I have a table that has two fields that of type number On the form level, I want to have value of the first field become the default value of the second field. I thought I might have some VBA code behind the afterupdate event of the first field to have the default value of the second field set.... I don't know if I am heading the right way. Can I get some help? -- niuginiki... 4 26.09.2006 05:13:20 Sendkey? I have the following function that does not seem to work (no error message of course): Public Function SendKs() SendKeys "^{'}" ' simulate the Ctrl and ' End Function I want to put this code in the double click event on a form, just to quicken the data entry. The idea is to copy the content of previous field into the current field. ... 2 26.09.2006 04:36:48 query criteria Hi, I'm new to using query in access, so I need some help. I have an unbound combo box that shows dates, but the tables have different ID with same dates, so I want the combo box to show a date only once. What should I write the criteria so that dates do not repeat. thanks esca007... 2 26.09.2006 03:14:27 how do i design an access database table for compiling all the law how do i design an access database table for compiling all the laws to help prepare me for taking a bar examination?... 12 26.09.2006 03:10:02 Transfer record Hi, How can i do this... I need to delete certain record (when i click the delete button) in the main table. But at the same time the record about the deleted item will be transfer to another new table which only consist of the details about the deleted item.So, in the main table, it will consist of only active item. My point is to make sure all the details about the deleted item will be at... 4 26.09.2006 03:06:49 wo xiang jiao pengyou Ô¸ÒâºÍÎÒ×öÅóÓѵÄÇë»Ø¸´£¿ WOULD YOU MAKE A FRIEND WITH ME¡£PLEASE CALL ME ... 1 26.09.2006 02:39:35 Table like word ? Simple question Hi I'm new to access and have designed a database for a customer. It is fine, only problem is that they want text fields to be possible to expand to second line like a table in word which they were used to. I don't know how to do this, when they hit enter it proceeds to the next field and not to a new line in the same field. He says that this should be possible. It is access 2003 ... 4 26.09.2006 02:08:15 Database sharing issues ... Looking for a little honest advice. I am about to share my database accross the company (approx 40/50 people). I have split the database up into front and back-ends and have applied user-level security. My original idea was to install a link on each persons pc which will open a shared front-end on the network (dedicated link required due to user-level security). However, now i'm starting... 5 26.09.2006 02:01:28 "New Record" methods (not Access "methods") I'm having some trouble programmatically inserting a new record into a table. The table contains one indexed field of the type AutoNumber. I'm tried using the SQL INSERT statement, but I run into problems doing an insert because I fail to include a value for the autonumber field in the VALUES portion of the INSERT statement. I haven't discovered a syntax that will allow me to do the insert ... 9 26.09.2006 01:44:16 Comment ! I have a field on a for called [Receiving date] , i have another field called [contents], i have a buuton "Export to Excel" ,that when i click exports the form's data into Excel. The question is : is it possible to export the field [contents] in the Excel sheet as a comment on the cell of [Receiving date] ? Regards... 7 26.09.2006 01:43:01 dialog box Is there a way to add a button or link on a report or form in access, that when clicked on will open a dialog box (like my computer) and let the user go through the tree and choose a server? Thanks,... 4 26.09.2006 01:26:26 this is probably very stupid, but I can't wrap my head around it I have a number field in my table that I just can't seem to get it to accept a number with a decimal in it. When I type in 2.5 it automatically truncates it to 2. I have tried changing it to Fixed, and everything else, but even in fixed and with decimal places showing, if I type 2.5 it automatically sets it to 2.00. The reason this is burning my ass so much is that I have two other time/date... 12 25.09.2006 23:55:07 Deal ticket database I'm a beginner on Access. I thought this would be the best place to find direction. I need to build a database where i can input information on buys and sells of natural gas that i've done. I'd have to put the customer i sold or bought gas to/from, the date, the days i did it for, a location, the person i did it with, price, price type and then i'd have to have the database print out... 3 25.09.2006 23:32:04 Continuous form - Counting records based on criteria Hi All, I have a continuous form, and need to count some records based on a date field. I need to put the counted total in the footer. I know I can use the COUNT function to count all records, but I need to count fields only when they meet certain criteria. (I.e. count all records where [Date] field is in the past.) It looks like the DCount function allows 'WHERE' criteria, but the ... 3 25.09.2006 23:20:13 901 Pages: <<  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  >>