Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. meirfridman

    how to host data?

    Hello everyone, I built a project in Ms Access with tables, queries, forms, reports and code snippets. (the program is intended for use online with multiple users logging on and using the same program). I now need make it available for use by multiple users simultaneously from remote...
  2. meirfridman

    To run a code which his source text is from a table

    Thanks you two. MakeItSo; I did what you said and indeed it works, so thanks for that. Progress. However, it only works for the controls in the main form not in the subforms. Is there any way round that that you can think of? The source code for the controls looks like this, if that is any...
  3. meirfridman

    To run a code which his source text is from a table

    Hi MakeItSo, Thanks a mill. for that. However it does not seem to work. (after this short paragraph of explanation for those less knowledgeable than you) I have pasted the code I entered that still does not seem to do it, giving me an “object required” error message. I am trying to build an...
  4. meirfridman

    To run a code which his source text is from a table

    Hello all, Is it possible to run a code which his source text is from a table? I mean, instead of writing: me.cmdClose.Caption = "Close" To write: ButtenLanguage = DLookup("fldAdress", "tblLanguagesInForms") When the value in "fldAdress" is 'me.cmdClose.Caption = "Close" ' Because when I...
  5. meirfridman

    Special Characters in INSERT INTO query

    Thanks for the tip. I tried but it seems that it have to be writen like this: NewData = Replace (Nz (Me.TypeName, "Empty"), "'", "''") Otherwise if the update(TypeName) is null, the function (Replase) returns an error.
  6. meirfridman

    Special Characters in INSERT INTO query

    Thank you Andy. I checked the rest of the characters and it seems that only the ' causes problems. I hope the problem is solved.
  7. meirfridman

    Special Characters in INSERT INTO query

    Hallo all, I am busy building a database with a table of log records recording any changes made to the foundation data. This is the code i use: CurrentDb.Execute "INSERT INTO tblLogRecords (fldLoginId, fldTime, fldAction, fldDescription) VALUES (" & LoginId & " , Now() , 'Changed type name' ...
  8. meirfridman

    Organizing many types of data

    Thanks a million for that MajP. I will study it a little and i hope i find a solution. I have already learned some although not an answer to my specific problem yet. i will persevere...
  9. meirfridman

    Organizing many types of data

    1. I already have more than a hundred situations (suspicious, some types of attacks, some types of attack with cold weapons, some types of attack with firearms, etc. divide in during the situation / in the past, there are casualties / aren't, etc. and dozens of other types of events who have to...
  10. meirfridman

    Organizing many types of data

    The problem, I suppose, is that fields where the answers are text will not be searchable, or sortable by the database. I cannot find any way to make the program search within the answers. I can of course make pull down multiple choice menus for most things, like hair or eye colour where the...
  11. meirfridman

    Organizing many types of data

    Hallo all, I am busy building a database for a personal security group, to record and organize the emergency calls coming in to the dispatcher. Calls are separated (internally) into events and situations, where events are the incoming calls and situations are the (details of the) possible...
  12. meirfridman

    Organizing many types of data in one field

    Hallo all, I am busy building a database for a personal security group, to record and organize the emergency calls coming in to the dispatcher. Calls are separated (internally) into events and situations, where events are the incoming calls and situations are the (details of the) possible...

Part and Inventory Search

Back
Top