Search results for query: *

Hi all I am having a problem when in DOS on a windows XP PRO machine. For some reason i cannot access COM port thru the DOS window. Any help would be appreciated. Raven

Hi all I have a form that allows the users to build a query, allowing up to 6 fields. I have another form that will display the results. My problem is it all works except i cannot get rid of the query datasheet with results. I have tried this code in a multitude of places docmd.close...

Hi all I am trying to make a form open to just one record, and the user be able to edit that record. This is probably easy, but i am having a brain cramp and cannot get it to work. THe form also has a subform in the tab control. i tried to use the find next command button, but i am using...

Hi all I am wondering if one or more of the expert programmers would give me insight into the difference between tab control and a subform. Is it just aesthetics? Is there a benefit to using one over the other? I see that i can add a subform within a tab control. Is a tab control more for...

I have an autonumber field that i changed the starting value. Well, now i need to change the starting value to a lower number and cannot do that. I have tried to delete the field, and that hasnt worked. I am to point were i am going to have to scrap this database and start over. Any help is...

Can someone tell me how to, or if it is possible, to restore just one record of a file. I have Veritas v8.6 backup exec. Someone has deleted one record of an access database, and i am trying to restore it, or look at it, so i can copy that file back into the database. I cannot do a complete...

If someone out there could help me figure out how to add a computer to a novell server, it would be greatly appreciated. I am used to windows based servers, and have no clue how to add acomputer to a novell one. THanks in advance raven

Hi all, I am wondering if anyone has an opinion, when building a database to be accessed from the web which is the best way to go, msde or mdb? ANd is it better to make a ADP to connect to database? I am a little confused and have been reading, still have a bit to do before i tackle this...

Hi All, I am having trouble with the syntax for a total. I have a select query that is grouped, then i use the this query in the recordsource for a report, also adding 2 other tables to it. all tied together the sql source is this: SELECT hoursvbill.WorkDescription, hoursvbill.BillableHours...

Hi all, I have a subform that i am inserting a new record into with code. It inserts the record into the number 2 position on the subform < it's a continuous form > not at the end of the recordset. In the table that it inserts the new record in it is in the last position. I know i have to...

Hi all. I have a question, i want to insert a new record in a subform and insert the previous balance from the record before it. I have the following function where i add the new record Function AddBalance(rstTemp As DAO.Recordset, Bal As Double) 'Adds a new record to the recordset using the...

Hi all, I am still battling the Previous balance in a subform. Do i have to create a recordset and then switch the previous balance that way?? or is there a way to bring the ending balance from record 1 to the previous balance of record 2? If i am not clear, what i am trying to do is create a...

Hi all, I am stuck as to how to create a brought forward total into a subform. I have tried 3 different ways and all of them do not work. Does anyone have any ideas?? I want to be able to use the total for invoicing, and need a previous balance to carry forward. Thanks Raven

Hi all, I am trying to insert current data from a subform field into a table. I am using this code, it isnt working. Dim db As DAO.Database Set db = CurrentDb() db.Execute &quot;INSERT INTO tblPayment ([CurrentBal]) Values (&quot; & NewData & &quot;);&quot; Set db =...

Hi all, I have the following code which works fine in 2000 but isnt working in 2002. I have checked the dao objects in references. but also have the active X references checked. is that what the problem is??? LateCharge is a numeric field (I thought no special characters needed for that...

Hi All, I am wondering how hard it is to make asp in access, i am just starting a tutorial book on it, it seems pretty straight foward. At this time i just want to allow user to view different information contained in the database. I guess what i want to know is if alot of code is required to...

Hi all I am wondering if you all could give me some input. I want to build a ecabinet with access, that would be viewable thru the web. Is this a realistic build? or not? The company i work for would like an ecabinet for certain files, and have the security to only let certain people view...

Hi I hope someone can help me i am running office 2002 with windows 2000 professional, and for some reason in the tools menu envelopes and labels are missing. Is this a glitch or have i installed it incorrectly? THanks Raven

Hi all, I have a table and in the first row first cell all is fine, but as i tab over to another column, FP will only allow me to be in middle of the cell. I have tried everything and connot figure it out/. Any help would be appreciated. CHeers Raven

Hi all I have a form that has a continous subform in it. I want to have a subform that will give a running total of sorts. What database is for is keeping payment information, i want this form to show the beginning balance and ending balance after all adjustments are entered. Saving the...