Search results

After some messing around and trial and error I figured it out :) At the command button, in the "Click" event I used this code Me.new_Nick_Name_txtb.SetFocus strSQL = "UPDATE Names SET Names.Nick_Name = " & _ "Replace([Nick_Name],'" & Me.Nick_Name_combob.Column(1) & "','" &...

Hello everyone, I've tried searching about my poblem but I can't find somethig about it (pretty sure it has to do with the words I'm using to search but anyway...) I have a table Names: (id, Name, Nick_Name) I have a form with 2 comboxes both based on that table. 1st combobox lets you browse...

Hi there jbraw, thanks for your reply. I watched the combobox2 video(the link for the combobox1 video ruterns a page not found error but I belive I know which video it is and I've watched both before) I already know how to do what is shown in the video. What I'm trying to do is this, lets say...

Hello everyone, great forum, I've got soooo much help from all of you guys!! Thank you very much :D:D I have a Database with Geogafical Regions, Municipalities, Cities etc. Because it's difficult to explain how my DB works using my tables( it has to do with how the system of municipalities...

Have you tried exporting the form to another database to see if you can save changes there? If you have a backup of your DB see if you can save changes on the form on that backup, also see if you can save your DB as mdb and ty to open it with a diffeent vesion of access (i.e. 2003).

since the "total amount" textbox is in the subform and the "taxamount" textbox is in the main form, you need to reference the "total amount" text box with a "full path" meaning Forms!MainForm!SubForm!total_amount_txtbox Replace MainForm,SubForm,total_amount_txtbox with your form's equivalent...

Cheers, worked like a charm :D Thaks a lot :D :D

Hello everyone, I have a table in which I store date about cities. Among other fields, there are two fields Title_1, Title_2 and both refear to the City's name, Title_1 has the city's name and Title_2 has an abbrevation of that city's name. In Title_2 there are some records that are null cause...

Yes, there isn't a pattern in the replacing of the names. It's names so there can't be any real pattern. The changes have to do with changes in the "newer version" of the Greek language. I'm not trying to find a way to make the changes auto-mated.I know it can't be done. But that's not what I'm...

Ooops:o My net must have screwed up-or something. There was nothing showing when I replied Oh well:o:o

:rolleyes:

Where did you use this IIF? Is it in an event of the the Final_Price_textbox which is in the subform? Is it in the event of some other control in your Main form? These [Quantity],[Menu Price] fields you are using, are they in the same form with the control in which you have used the expression?

What do you mean? If it is "Text" or "Memo" etc? It's "Text"

The reaso I posted the question was to see if there was a simpler(that's quite relevant in this case :D ) way to do it cause I belive it'll be faster to write a query / some code or whatever than open the table-> Ctrl+H-> input "old name"-> input "new name" . This table has 13272 entries. Anyway...

Oh, sorry my fault there for the incomplete info:o. There isn't any record with the "new names".So, since there isn't a list that matches "old names" with "new names",I have to manually check the list of the "old names" and write the equivalent "new name". Maybe an example of what I want to do...

Wait,which two tables? I have one table?:confused:

Hello everyone, I have a Table and in that table I have a field,named "Title_1", which contains names of different cities.I have duplicated that field and named it "Title_2". What I want to do is to raplace many of the names of the cities because from the source I got the data the names of the...

Re: How to change Report Table Text before printing? If you have a question to ask then start your own thread

In the "14Dugs" form for example,the lines you refer to are below the "tbAuditTrail" textbox and above the "drgclsc1" and "drugs" comboboxes? If that's what you are talking about, it seems it has something to do with the "Form Header/Footer" of the form. When I removed it the lines were gone...

One more think, could someone please be so kind as to tell me how to make the cursor to change to the typical "Over Link Cursor"? The pointing hand I mean :)