Search results

hmm you know what I think I understand now. Anything can go into preferences, and any individual can have those preferences. I just forsee it being difficult to use a crosstab if I would want to display all persons and have all their preferences as fields. Thank you boblarson for your help...

Thanks for your continued input boblarson. Iv taken a look at your sample database. I still dont think I cant get away without adding new fields. For instance I currently have a similar design to you db as you can add in new preferences, I can add new treatments for each animal. However what if...

Oh yes i came across that site too amongst others, however I think that is just for changing the data type, such as from a Number to Text type . I have no problem doing that. Its just when iv added a new field as datatype Yes/No the format is by default in "-1" and "0". I would like it to be...

Is there a better way to allow a user to add fields? Or in general its not good practice to alter tables. Also I dont seem to be able to find a way to change the format using the ALTER TABLE method.

Thanks, Ill have to look into it.

Hi there, I have a form that adds new fields specified by the user to a table. My only problem now is that I need to be able to change the format of the new field. Right now the user chooses the fields name and data type. However when the boolean or Yes/No datatype is...

Hey Cheers dude. So i reorganized my database using an autonumber as the main connecting field while keeping Study Name, and now all is well. :)

Hi There, I have created a database to record research studies data. Everything is organized as I want it, but I cannot modify a field (Study Name) which is in pretty much in all my tables. I have all my tables linked and the option “Cascade Update Related Fields”, yet when I...

Hi There, I have created a “Single Form” which I want to now change to a split form. I can do this easily by changing the “Default View” of the form in the properties window to “Split Form”. However the datasheet portion now appears above the whole form, even above the header...

SOLVED!! Re: Query changes drastically complex after saving and reopening !!SOLVED!! I believe I have solved my problem. Instead of creating the query in the design view I coded straight in the SQL section. I also coded in the SQL section so the criteria would be in their...

AND THE REST OF THE CODEING: demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Lung Function Non-Exace Associated].fevpred) Between...

Yeah I dont think those are the real issues. I am rather descriptive with my naming. Thanks for highlighting the special characters problem. I think it is a good idea I get rid of those. Erm I cant post it all in one go as im limited to 25000 characters. Anyways here is the new code Access...

Thank you for your time and consideration, I wont blame you if you give up though. This really doesnt make any sense to me whatsoever. Basically i have two tables linked and fields from both. In 5 fields I have criteria such as: [Forms].[Main Switch-board].[LMMut1] Or [Forms].[Main...

Hi There I have a somewhat simple query, that once saved and re-opened MS Access changes the programming to be drastically longer and more complex. It still works as it should, but as soon as I tamper with it, it no longer runs. It states (and rightly so) the query is too complex...

Could you please repost that Link? I get a no match found page appear when I click on it. Cheers :)

Thanks for the reply. The last coding I had found(in my first post) was indeed code used in excel, I'm just not sure how to translate it to work in Access. Thats a good suggestion recording actions in Excel using macros. I shall try it. It might be easier for me to simply calculate the linear...

Hi There, I am using MS Access. I am trying to obtain the value of the trendline equation from a chart. The chart is premade and on a split form. I have been trying to obtain the equation using VBA. The best way may be to use the MS Excel reference library or the graph library. Yet all...