Search results

Hello All, I am new to vb and just trying to build a database for work. The db works ok however I am trying to modify the output location since its on a network. The current db report output locations is... "C:\Documents and Settings\a124567z\Desktop\ContactInfo.rtf" with "a124567z" being the...

I think I finally figured it out how to delete the records. I did it using a macro. Now I am trying to use run code to get it to append

In other words, I should change the make table query to an Append query right? So how do I set it up to delete and replace all entries when I load it?

OK guys, I was wrong somewhere. I am sorry about that. I tried using the link table option but could not find my source table in DbOld. I then went back to DbOld and looked at the tables. Behold, the Table that has the info I am interested in has a sort of globe Icon with a link table arrow on...

The table on DbOld is very big and complex and requires an ODBC connection that I cant get. So I am creating a table from a query. I however got the code to run when I deleted the TblNew from DbNew and made the form an unbound form so I guess if there was a way I could delete Tblnew on load and...

Hi all, I am trying to update a table in a database (Lets call that DbNew). I want that when DbNew form is loaded it automatically updates its underlying table (lets call it TblNew) by running a make table query (called "coversheet") that is located in another database (call that DbOld). DbNew...

I took it down and now cant even upload another. I am so frustrated you have no idea. I will keep trying though.

Guys I need help please, I have this db that I have been trying to get to work and been unable to implement llkhoutx suggestions successfully. Its an existing database that I wanted to modify. This is the idea I have or want to implement. I want that when a user opens the db he/ she should get...

Well I did as you said and Still having the same error. This is the final query copied from the SQL Window having built it as you suggested Here are the other properties: Tables: States- StateID (Number, field size= Double), State(Text), Alias(Text), RFCodeState (Text), Additional Info (Tetx)...

llkhoutx, Thank you for the reply. I really appreciate it. I am new to Access and just copied the query from the SQL Window (I did it in design view) Anyway, I tried using the bold part you suggested and it gave me an error (Data type mismatch in criteria expression). I am still trying to...

I need some help please I have a db that has three forms (1 frmSearch, 1 frmFindCountyInfo and 1 subfrmFindCountyInfo (embedded in the frmFindCountyInfo) I also have 2 tables (States and CountyInfo with StateID and CountyID set as PK in each). Now I am trying to design it in such a way that when...

Hi, Sorry for the late reply guys. I was on vacation. I appreciate your help. The form works fine now and I must say I like your suggestion and I would do a few tweaks and use it. Once again, thank you very much! Happy new year to all

Greetings all! I am new to access and trying to build a database but having some real issues with the pop up search. Its a database with personal information so I created three forms 1. FrmMain = The initail navigation page which has just buttons and no records. When you click the cmdFind...