bid on fixing my screw up

[Dick7Access]

I have a Switch board on client’s db, that I screw up. I am wiling to pay a reasonable price to have someone fix it, I will probably have to send it via MediaFire so here is the URL: http://www.mediafire.com/#myfiles, email is: dsoniier2@ aol.com. The file is called DB200 If you’re interested send me a PM and I will send you back the password.
Take a look at it, and see how much work you will have to do and send me a bid on a pm an see if we agree on price.

Dick Sonier

 

[Alansidman]

Dick,
No file available. I think that you need to sign up for media fire in order to access it. Only able to view their marketing of the site. Suggest you try something like Box.net where it is free to post and share.

 

[Dick7Access]

Dick,
No file available. I think that you need to sign up for media fire in order to access it. Only able to view their marketing of the site. Suggest you try something like Box.net where it is free to post and share.

PM keeps telling me message to long no matter how short I make it, but this part doesn't have to be private anyways.


This db was made over ten years ago, by a Bible student who he has since lost contact with. He himself knows nothing about access. I am making him a new one from scratch. How I ended up messing up his old one I was trying to fix something on the old one and he was telling me all the things he wanted on new one and did not pay attention to what I was doing.
If you will look at the switchboard form it has 8 cmd’s. Each one had something in the 8 labels. This is were I get lost, as when I look at the switchboard table it has 15 item. I don’t remember if I ever did know which ones he had in the switchboard form. If I look at the project explore in VB it seems like that should tell us what went into each cmd, but I am just learning VBA so I am not sure. If I am correct then that is what you will have to restore the option in the switchboard form. Let me know if I am correct about the vba.

 

[JHB]

If you will look at the switchboard form it has 8 cmd’s. Each one had something in the 8 labels.

Each cmd is filled with a "label" caption normally coming from a table. I can't imagine it should be difficult to recover the Switchboard.
Do you or he not have a copy of the database?

You can find the name on the table by opening the Switchboarden and see in the code behind the form.

Copy the Switchboard form and the above mention table to a new database and lay it op here,(we do not need to see some other data), then we can look at it, then I'm sure you'll get it recovered for free.

 

[Dick7Access]

Each cmd is filled with a "label" caption normally coming from a table. I can't imagine it should be difficult to recover the Switchboard.
Do you or he not have a copy of the database?

You can find the name on the table by opening the Switchboarden and see in the code behind the form.

thats most of the problem his original is back in PA and he is in
south florida. I on the other hand must have taken am extra stupid pill that day, as my first computer school lesson was Backup, backup, and backup. The form switchboard cmd buttons and their corresponding labels are missing in form view but the labels are there in design view It looks like the vba code will tell us what belongs where, but Ijust started learing vba, so I am noy sure. If you want to look at it I will PM you the password,but Alan has first bid.

 

[JHB]

I can look at it, but I don't want to bid on it, (I don't want any money).

Can't you copy the Switchboard form and the corresponding table to a new database and lay it op here?

[COLOR=red]'You can find the table name here.[/COLOR]
Private Function HandleButtonClick(intBtn As Integer)
  ...
  ...
  ... 
'The table name is here "Oversigtselementer"    
Set rst = dbs.OpenRecordset("[COLOR=red][B]Oversigtselementer[/B][/COLOR]", dbOpenDynaset)
  rst.FindFirst "[SwitchboardID]=" & Me![SwitchboardID] & " AND [ItemNumber]=" & intBtn
  ...
  ...

 

[Alansidman]

Dick,
I am interested in helping, but do not want any money either. Suggest you let the whole board help on this as many heads working will solve the issue.

For confidentiality sake, you could copy the db and sanitize the personal information and then upload the sanitized version for the sake of the board.

Alan

 

[MSAccessRookie]

What they said... and I am sure there are others who will pitch in as well.

 

[Dick7Access]

You guys are super. Most times I try and work db learning out myself with just a little help here and there from the forum, but this is a client’s db that I didn’t even make. In one way it’s a waste of time as the one I am making him will be far better. For example he has a field for every lesson. I put his lesson in a separate table, but in the meantime he wants his old one back. At times I had a site that I would go to called rent-a-coder / V/workers and I could offer up a problem and they would bid on the job, but they have been bought out and they are not available for a while. I had already sanitized db200, but I had to remove the other db I had on Media Fire before I could let the site go public. This is all you need to get into it. I Thank everybody very much.
Dick Sonier
http://www.mediafire.com/#myfiles
Dsonier2@aol.com
pssword: Brian7ly
Db200

 

[Dick7Access]

Just to interject a little humor into my situation it is funny to me that in my circle I am the expert in Access. It reminded me of what my lawyer told me when I ask him why, since he was so good, that he was practicing law in such s small city. He said he would rather be a big fish in a small pond, than a little fish in a big pond. I also need to get my clients back in business, because who knows when I will get his new one finished. I am not a fast coder, and I am not a slow coder. I am a half-fast coder.

 

[JHB]

You only have to change the "On current" property to "Event Procedure" for the Switchboard form.

Se picture.

 

[Dick7Access]

You only have to change the "On current" property to "Event Procedure" for the Switchboard form.

fix I think. One thing that was throwing me for a loop was that the switchboard form in design view shows eight cmd's, but evidently they are not all populated.
Many many many thanks to everyone.

Now I know that this is too much to ask, but do you have any idea what I did to screw it up?

 

[JHB]

No, the word there were standing in "On current" property was "mrcBtState", I don't know where it's coming from, maybe you recognize the word.
I think it was something from the clipboard, you copied in, mistakenly!

 

[Dick7Access]

No, the word there were standing in "On current" property was "mrcBtState", I don't know where it's coming from, maybe you recognize the word.
I think it was something from the clipboard, you copied in, mistakenly!

Thanks again!