Search results

Thanks a lot. I presume that in the Replace function, the place marked by you as LastName is the filed name I wish to have my replace function to act? So if my table name is BData and the field i wish to update is PPMother then the statement should be like this: UPDATE BData SET PPMother =...

Another thought: Replacing all the data would mean storing it in the database with the html tags, right? So just in case the data has to be used somewhere else for filtering or say some query, we will have to consider these tags. Is there a way to add tags when the record loads in the form? How...

I tried it in the query design grid. But it seems the Replace function doesn't work there. Another thing I tried was to put this in the criteria field: "*" & Chr(13) & Chr(10) & "*" and in the update field: "*" & "<BR>" & "*". This resulted in the field being updated to "*<BR>*". I have been...

Thanks. But it doesn't help. Tried but failed miserably. Lucky I had made a duplicate of my DB.

Thanks a lot boblarson. That has worked. BUT what about my previous records? There are about a 1000 of them. The old records still show the same behaviour because they have been stored as plain text in the database fields. The new records will be saved withe the tags. Any method you can suggest...

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...

Thanks a lot.

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...

That does work as intended, ByteMyzer. BUT everytime I wish to run a query I have to first open the Singers Table, search down the list for the singer/s in my mind, look up their corresponding IDs, go to the SQL window and substitute those IDs into the proper places. If I can avoid looking up...

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 tried using this code in a form in the afterUpdate event of textboxes. works fine. BUT when i enter a multi-line text in a fiels for address, only the first line is properly converted but the remaining lines rae unaffected. How do u work around this scenario? I will attempt some coding as soon...

Thanks a lot.

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?

Set the visible property of the subform to False on the Click event of the button u wish to use for the purpose. e.g. ..... If Forms![subFormName].Visible=True Then Forms![subFormName].Visible=False Else Forms![subFormName].Visible=True. End If ... ...

Thanks a lot for all your help.

As you must have seen in the page set up I have a left margin of 0.75" and right margin of 0.25" giving a printable width of 4.5". Still after reducing the width to 3.9" also I get the same error. Any explanation for that? There is something wrong with my design but I cannot pinpoint the...

I am attaching a file with some records. I have removed all irrelevant tables and queries and forms. There is a module which generates the string necessary to write the certificate for the report. A textbox in the report gets the data from this function. I need to use the specified size of...

Have u tried VB Code Library? It works well with VB so I guess it should with Access VBA too. Nice application.

I use HP Laserjet 6L printer with its own drivers. The problem does not occur if I change the page size to 8.5" x 11".