Search results

Ok so I don't know how to change the path on the fly Here is the code I used Call RefreshTableLink("AM_Asset", Me.FilePath) Here is what is in the FilePath Text box N:\Shared\VotingEquipmentTracking\041102 - PresidentialElection\041102 - Presidential General Election_BE.mdb The Error I get...

Ok, I don't want to hard code the name of the table or the path because iether or can change. So what do I need to do. Currently to change the path there is the open dialog which enable to browse to the desired db. I think I might know how to use that to change the path. I'll try Is there a...

about to implode

It highlights the Call RefreshTableLink

I get a compile error when Icall that code. Where exactly do I put that. I tried it in a new module.

I'm trying to use code to relink the the table but that is not the only table that is linked in the DB. The other linked tables are in other databases so I want to select specific tables to relink as the others may not need it. I alway will want to select the path. here is an example of the...

Well After thinking about it I just created and unbound text box and have sub forms based on a query. The qurries have the unboud text box as the crtieria and I used If staments to only requery the subs I want.

I want to search mutiple tables. The tables are different tranlations of the bible. Edit: I want to be able to select which tables I search

Couple of ways Make that field 0 in the tab order or On load event for the form Me.[Your Field].setfocus

Found the left function it was part of the MSysObjects for the reports Made the changes you suggested for report table. Any sugesstions on usability and functionality?

Crilen007 Thanks for the bug report. This is probably only going to be used by a hand full of people in my office. Personaly I like trippy stuff but I thought I was pretty conservative When it opened did it open with the menu form? Colors: Should have been black and blue but maybe I have...

email Exodus31.15@gmail.com

any takers give me unyil late afternoon tomorrow.

I did that and imported into a blank db the smallest i get it all stripped and zipped is 127k but it leaves out a lot of the reports

Try using a query with criteria base the criteria of the fileds of your report Like IIf(IsNull([Forms]![FrmReportCriteria]![Serial]),"*",[Forms]![FrmReportCriteria]![Serial])

I've been working on this project for about a month wanted to know what you guys to get to the db double click the small command button near the graphic on the menu form the password is exodus. you will have to hit f11 to see the db window. don't bother holding down shift when opening I've...

Sorry I failed to think of that potential problem. I would have the forms close when the report opens. but then the users could get to the tool bars. An even better solution is Hide the access window all together. but this requires you to put the report in snapshot view. See this linkHide...

We both been typing while the others posting it can get a bit confusing.

Check my example

see this attachment It should ge you in the right direction