Search results

I have a yes/no msgbox which is thrown if a value entered is not part of the maintanence tables. HOW do I capture the yes and no selections? if YES is selected then I want it to open a form "frmMatrix" to acNewRec if NO is selected then I want to open another form "frmRecEdit" If...

Sorry, lost my internet for a while... You hit the nail almost right on the head. find all instances of the prefixes(from tblPrefix_Outlets.Prefix) in the tblWater_Sample_Temp.ClientID. take that information (e.g. EN-15, MTG-65) and compare it to entries to another table(tblLocation.Outlet)...

I had actually already made my own, but wanted to be rid of any trace of MS in the startup! Thanks for hte advice though!

good call! ~THanks

I have a db with a .bmp in the same folder and the access 2000 db won't show it instead of the access splash, and ideas.

While that is a great approach, and I though of trying that (though I wasn't sure how)... BUT the problem is that it will not always follow a '-' and there may be locations like 'HZ250-EN-05' which would then only extract the 05, as well there are ones that neglect the '-' altogether! I...

I have a temp table where I import data from an excel file to. I do some work on the data in the table, but am having trouble with this part. The field(ClientID) in a table(tblWater_Sample_Temp) contains information like: HZ540-EN15 HZ540-MTG I also have a table(tblPrefix_Outlets) which...

that would be nice, but they can add a new record or edit a record that is already there. And how do you set a from value from a subform, or vise versa; check a subform value from a form?

I have been stumbling over this problem for a while now and REALLY need some intervention on this. I have a form subform which contains information and of course related information (one-to-many). I need to capture the event of a change in the subform and set a radio button to enabled on the...

Perfect as always FoFa Thanks

I am using access 2000 but since I have the other stuff working, I'll not play with that right now, but I will be touch ing this again soon, so it would be appreciated. RIGHT NOT THOUGH... I want to find all records in a field tblWater_Sample_Temp.Result that have > or < at the beginning...

I want to find all records in a field tblWater_Sample_Temp.Result that have > or < at the beginning and remove that character. So that: < 35 > 3 Would become: 35 3 Any Suggestions?

Select Into How Can I insert the results of: SELECT tblWater_Sample_Temp.Result FROM tblWater_Sample_Temp WHERE (((tblWater_Sample_Temp.Result) Like '*-*')); into: tblWater_Sample_Temp.Note

I am hoping to do some coding to automatically edit entries in a table. The data is imported to the table via a button on a form and then displayed on the same form. I am wondering if anyone has an example of how to do this easily. I am looking to do this in a single table, searching one...

I am using calendar control 9.0 with the calendar form to open the calendar and I have but 1 problem with it... I want it to open to the current date rather than just whatever it feels.. Is there a way to do this? I am including the form incase someone else wants it and or feels like making...

ANSWER: use: Dim mypic As String mypic = txtLogo.Value imgMyPicture.Picture = CurrentProject.Path & "\images\" & mypic Add this code to the on_current event for a form, Add this code to the detail_format for a report. :rolleyes:

I know this has been covered in many instances before and am sorry to bring it up again. I understand the thought of linking an image and all that jazz, but I find that Access is limited in it's functionality in that the path has to be hard coded rather than relative. I wish to have images in...

Hello all, I am currently working aon a database with many aspects to it and I am wondering about the importing of data once a month or so. The company receives a file in .csv format and are willing to do some editing to it to make it compatable with the database but not a lot of editing. I...

Hey all, long time no see... I am wondering about how I can go about viewing / convertig a .tps file to an excel sheet or something which I can easily work with. This is from a dead system which the information is burried and I need to migrate it to a newer system soon. I am unable to find a...

could you elaborate, or point me to a relative place to describe this?