Search results

Well I found an solution to Issue2 thru some feedback by Big Jon Booty He had another solution to that I didn't use. you can find the thread here http://www.access-programmers.co.uk/forums/showthread.php?t=210006 This also inadvertenly fixed Issue #1. No more error.

This worked great. Thank you very much.

Well when I tab out of field other it's supposed to go to field alt_id but it goes to the next field in the tab order. I'm trying to solve an issue I have in a subform where I don't want to go to the next record. I have posted the db and my issues here...

I have tried to do this but it doesn't work. My code on the lostfocus event is Private Sub other_LostFocus() Me.alt_id.SetFocus End Sub

Well I am getting close but not happy. I have created a db where the user will enter who has come to our open house. I created a form for customers that we currently have and another form for new customers. The current customer form, [frm_current_register] is fine. It works how I want it to...

Thank you. Yes I could, and I might have to. I have been trying different things for days now. I wanted to keep the user on one form. If I can't get a workable solution that keeps them on one form I will add a command button that will open a form where they enter will enter the corrected...

If it was that simple I would do that. But what about new businesses? What about the corrections to the existing businesses? What about addition info of an existing businesses gathered at the open house? If only existing business where coming it would be alot easier.

I have been given the task to create a db for our open house where we can record who shows up. We have our current businesses[extend_names], new bussinesses or corrections to be made to our current bussinesses[2011_attendee] and the contacts for both[2011_attendee_contacts] When someone...

I created a unique identifier. In the query I combined the 2 fields together as the unique identifier. that has solved that. Thank you.

In my form a have a combo box. I want 2 text fields to show the column 0 value and the column 4 value of the combobox. I have set the control source of the text boxes to =[Combobox_name].[Column](0) and =[combobox_name].[Column](4). This works untill I have selected a record in my combobox where...

Here is what I have upto now.

Hmmm. Maybe I'm not doing this right then. I think I need to start from scratch on this one. On the main form I have a combobox that stores the bpid of the selected record. I linked that value to my 1st subform to give me a set of records. That subform is uneditable. This subform1 is using...

I think I know the issue which is what you have stated. In my main form is a combo box where I find the record I want and select it. That box shows the [name] field but holds the [bpid] field. the subform looks at that and brings into it that record. I need to add(and hide) the alt_id field in...

Well the form and subform share the same recordsource, which is a Union query. And the bpid and alt id are in the same record, different fields.

Even the labels won't show?

I have a subform form that I linked to the main form on the bpid. I view the form and all is good. However when I try to link it to the bpid, alt_id of both the main form and subform all the stuff in the subform disappears. The text boxes and labels all vanish. Strange.

I'm back on the prowl for a solution. We have tried to access the desktop db with logmein and that won't work. Even when I resize the forms. I don't have the type of expertise needed to create a web application. I think. Never tried but little knowledge of it. I have searched for mobile db...

Sorry Spike I'm not going to install the db on his phone just access it. So I would have to put it out there on a server or something. I would think that I could put the mother db on a sever somewhere. Create a mobile db(Litedb) and put it on the same server with links to the mother. I would...

Would it be easier/better if he used something other than an Android? I searched and found an iphone/ipad app. Not sure if it's any good but some of the reviews looked positive.

A client of mine is going to want to access his Access db from his phone. It resides now on his desktop computer. What are some of the challenges I'm going to face doing this? His phone is one of those Androids, not an iphone.