Search results

I first need to explain what I had working well in Access 2007. Pt_Data form has one text-box named txtPP. There's a button labeled Prescribe which opens another form frmSelection. The selection form has 3 list boxes listing 1)Antibiotics, 2)NSAIDS and 3)Miscellaneous. What I did was select the...

I need some code to print out the complete structure of my database. There are many tables each with many fields. Also many queries. So i need to write a routine which will at least output the structure - table_name, index, field_names, field_data_type, and field_size where applicable. I had...

I have this database on Indian Film Songs which I made for personal use. I must explain a bit of databse before posing the question. The songs are sung by singers(may be one, 2 or sometimes even 4-5) So I made a song table, a singers table and a join table like: Song Table SongID Song...

I have this main form. There is a cmd btn on the form which opens another form showing more information on the relevant data in the main form. I want this form to be positioned so that the data in the main form is still visible. What code should I use to position my new form? I tried...

I have a suform on a form. The subform displays in a datasheet view. There is a column of its Primary Key which is generated bya certain code. hemce I do not wish to show this column on the user interface. how do i hide this column? will it have to be done in code?

I have been trying to create this report and every time i get this error: "The section width is greater than the page width, and there are no items in the additional space, so some pages may be blank" My page set-up has a custom page of 5.5"(w)x8.5"(h). Margins are set to Left, Top and Bottom -...

I have a table named companyDetails which stores the name address, phones, Director names and a logo fields. The logo field is a OLE field and I have embedded the logo of the company in it(it's a jpg file). When I load the forms I open this recordset to fill in the details in the form header and...