Search results

Hi everyone, I have been trying to pull out common fields in a textbox above a navigation menu so as I browse and search for something if I click on a different menu (say hospital in the example attached) the patient name would still be visible. Ive been reading past threads and I remember...

Thanks for that DBguy. I changed the datatype and it worked and have changed the controls also as Pat suggested

Hi Pat, thanks for your comment, I have changed my code as you say. I had been using Hungarian notation in the database I am working on but got lazy in this example, sorry. I didnt get an error with the form not having a bound control, but did have to update my code as the textbox, button...

Thanks DBGuy for that and the rest of you guys, I'm guessing that the Hospital tab is blank because I forgot to change the datatype to number (there may be another reason) if I could have some further advice please - then will leave this search box alone! Within the Hospital form in...

Hi theDBguy, I have made something up that tries to explain a bit better. Excuse my lack of imagination! but hopefully the principle is there Basically trying to see if I can get a search function to work outside of the menu to pick up the patientid (becasue it will exist in more than one...

Hi everybody, Hope somebody could help me with this please I am trying to redesign my main menu and move a vba search box so it sits outside and above the main navigation menu on the form . The field I am trying to search for, lies in more than one form which the user can select by selecting a...

Thanks Pat, what would you class as small tables? Sharepoint would be the easiest option at the moment, is there a db size in which I should start considering other options?

Hi Everybody, I learning MS Access and ive have been asked me to build a database, there will only be a handful of users and maybe a few thousand record entries. The users of the database will be at different locations and their computers are not networked, so Ive been thinking of putting the...

Hi, thanks - the trouble is there are going to be several forms that need to reference the primary key, so trying work arounds but not having much luck

Hi there, I have 2 tables in Access, the primary table is called tbl_Clients, with a form frm_Clients, which is used by the user to create a new client record, tbl_Clients has a primary key ClientID. The second table is called tbl_Reports with a form, frm_Reports, this table uses ClientID as...

Thanks Pat I will make the changes you mention and give it a go. Thanks for your time

Hi I'm new to this website and have been advised to move my question to the VBA forum from Access. I tried to insert the link but then could not post the thread so removed it. Sorry about this but I am new to VBA, I know a bit but stuck on how to do this - so if anybody could help me with...

Hi Sorry about this but I am new to VBA, I know a bit but stuck on how to do this - so if anybody could help me with this please. I have hundreds of forms as ms word documents in the format below and would like to import them into Access. So that the data in each form comes under one common...

Hi Didier!

Hi, Ideally I need to look over an email folder, with lots of attached MS Word forms and get Access to open each attachment and pull the data in from the form, taking data from headings in the form such as NAME, ADDRESS,DOB etc and read the into field headings in Access (the data in the MS...

Hi everybody and thanks for the welcome! its good to be here. I have a question on how to import MS words into a table in Access. Just thinking maybe I'm on the wrong forum! - think I need VBA for this But if anybody can give me any help I'd be very grateful. Ive attached a small sample word...

Hi there, First time visiting this site - nice to meet you all! I am from the UK, live in Liverpool and my hobbies are mostly sports. Cycling and football mainly. Recently had a bit of a job change within my company, so now moving from excel to database design in MS Access. so the database...