Search results

Hello, Must Outlook be installed for Access to send emails? Can I send emails from the Run-Time version of Access? (with and without outlook) Thank You!!

Hello, I am looking for a good book on database theory that I can read while away from my PC. When at my PC i have intentions of spending time learning, but I get busy doing other tasks. I am hoping to get a solid grasp on database structure, splitting databases, database deployment, front-end...

That's what I thought. Maybe I need to find a computer that doesn't have Access so I can "see" what happens when Run-Time Access is installed and the database is launched. The user is 6hr drive away from me so I was trying to work him through it over the phone. Thanks

Hello, I recently developed a SKU generator for a garment company, and I am trying to figure out the best way to deploy it on his computer. He doesn't have Access so I'm trying to figure this out without making him buy it. I tried running it in the Run-Time environment, but he wasn't able to...

Great! Thank You!!

Hello, I am working on a SKU generator and I need to prevent duplicate SKUs, but each SKU is made from several different fields. i.e. Brand, Color, Design, etc. I was wondering if Concatenating would be OK for this situation. I know concatenating usually results in redundant data and I try to...

Mahenkj2, You are a gentleman(or Lady... idk) and a scholar!!!!!!!!!!!!! Thank You!!

Hello, I am about to allow users to access a database I redesigned for others to use. I am trying to save it as an ACCDE so they can't mess it up. The database is very very simple. 6 tables each with only 4 fields or less... and none are related to one another 7 forms. 1 report. 0 queries...

I'm going to look into running windows on the mac. It's a beast so even if it slows it a bit it should be fine. Thanks for the reply

Hello, I have a database(access *.accdb) that I've been using on my Windows 7 PC that I need to move to a Mac. Does anybody have a recommendation for a good and cheap way to do this. In addition to converting it to something a Mac can use, I need it to be functional so a suggestion for a...

He knew when

Awesome! I am excited to implement that Thank You

I've had a similar problem and fixed it by adding a control, makinging it tiny, and putting it in the corner or behind another control. Set the tab stop to 0 so it is selected when the form loads. IDK if this is what your problem is, but mine was due to a control being selected and the...

Hello, I need to use an algorithm to derive a driver's license for each lead as each record is created. The fields in my table used in the algorithm FullName (LLLLL L LLLLLLLL) aka (FFFFF M LLLLLL) DOB (99/99/9999) Here's the algorithm LLLLLFMYYXmb LLLLL - Last Name, truncated - The first...

Oh, I got it... my UpdateQuery wasn't working because I has the form control in the wrong parameter. (It was in criteria not updateto)

Hello, I am working on a database to track which SalesRep gets each Lead. I would like to update the data in the Leads table several records at a time; does anyone have a good method to start a task like this? I have an idea, but I'd rather get suggestions on the best way... not a way to make...

I've looked at the example, and I am trying to do what the example shows but backwards. The example allows me to select a record from a popup and navigates to the appropriate record on the subform (a continuous subform; list). I want to select a record from subform2 (a continuous subform...

Thanks for the reply. I will play with it over the next week or so and repost my results.

OK, create your combo box and add the following where condition to the after update event (in a macro or VBA) ="['Field that will define every record in table, like a Primary Key'] = " & Str(Nz([Screen].[ActiveControl],0))

Try creating a combo box and use the third option on the first screen of the ComboBox wizard... "Find a record on my form based on the value I selected in my combo box." Play around with that