Search results for query: *

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...

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 ="*****" &...

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...

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?

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...

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?

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...

I have a form that uses a number of update queries to determine a value. How would I put all the update statements into one query?

I have a form where the user is to enter data. In the pull-down lists, the user may choose one of the options, but may also type in an answer. How to I make it so that the user's typed in answer is added to the list so that it may be chosen in other instances?

Hi, I am very new at this and need some help. I have a field of start date, end date, and value, and then a test date and total. If the test date falls in between the start and finish, it adds its value to the total. I really have no experience with macros or modules so exactly how would I go...