Search results for query: *

It's not wiring in the dorm because now I have it at home and it's doing the same thing. Its got 512 Megs of RAM so I don't think it is a memory problem. It's 1.3 Ghz, only about two years old. I've got another power supply here I'll try and put some more heat sink paste and try another fan...

Thanks for the tip, I'll do that -matt

Hi everyone- I live in a really tight dorm room and have recently had some problems with my computer. It often freezes or shuts off for no reason, and my motherboard is sometimes reset to the defaults. I've reformatted and had the same error and have run diagnostics on the memory and video...

Believe it or not, it would only take [EmployeeNumber], not [EmployeeInformation].[EmployeeNumber]. Thank you both for your input.

I'm sure this has been answered before. On a form I want text box filled with a value calculated by the expression builder. It is used to hide most of a number, as you would a credit card number, but have the last few digits shown. Ideally, it would appear ="*****" &...

Thanks, thats exactly what I'm looking for.

Hello - I have a database with a master table that contains almost all of the information I need. I want to write a piece of code that will start at the first record, make some calculations, save the value in one of the fields and move onto the next. The calculation and save I can handle...

Thanks, that works well.

I am working on a database in which the user types in a path and the corresponding database is linked, processed, and deleted. I want check if the path actually does point to a file or not, in the case of misspellings or what have you. Is there a VB function for this?

Sorry I've posted on my own thread so much. I took out the bullet proofing stuff and it works great. Thanks again. -Matt

I put in your code, got it so that it runs and doesn't come up with errors, but it does not alter tblEvents. I have a form with 2 date boxes, Name is dtStart and dtEnd. Any thoughts?

Wow, thanks a lot, I'll see what I can do with this. :)

I need to create a table of all the dates that fall between two dates that come from a form. A query will later assign all the records a value to coincide with the date. Any idea on how I can make this?

1) I have a form, and from the form two dates are entered and something needs to make a table where every date is a field. Any ideas how to do this? Either SQL or VB? 2) After the above table is created, I have a chunk of code that runs a number of queries to update a value based on the date...

The thing is, the table will be filled with information and then sent back to the home computer. So it doesn't quite exist yet to make a connection to it. ODBC is a little beyond me at the moment. :) DoCmd.TransferDatabase I believe is what I am looking for. Thanks anyway!

Yea, I am so new at this anything that works is a triumph.

Hello, I am attempting to utilize the TransferSpreadsheet function in VB to link a table to my current database. However, there is no SpreadSheetType reference for other access databases. Is this the wrong command to use or is there a reference for an access table?

Sorry, I was unaware. I poked around in the resource scheduling template that comes with Access (2k) and the way they do it is if it is not in the list, it brings up a message to double click, and when double clicked it brings up a form where you can add an entry. The NotInList Event helped me...

That is the command I am looking for, thanks.

hello, i have a master table, and table that is to be linked and an append query that is run that combines the two tables into the master. I was wondering if theres is a command (sql or basic) to link the other table and choose the table to use. It will have to be done a few times, which is...