Search results

I know I am beating a dead horse here but I need to get it out there. I have a form that has validation rules, etc, and I want to let the user close it with custom error handling, so I was building a validation procedure for a form close button. The thing is, whether using Isnull, len()=0, or...

Hi All, My application is close to done so I am looking at install procedures. I like SageKey but they are still testing the MS2013 install wizard. So I plan on trying Inno. I am using MSA 13 and my main question or hurdle is thus: How do I tell the wizard what to do to relink the front end with...

Yeah its not there. It looks like there are no install wizards for Access 2013 yet, even SageKey has not realeased one. Bummer.

Does anyone no where to get the package wizard for access 2013?

Hi All, I am sure I am not the first to try to do this. I have a form that posts to a database with calculations. Thing is, I want to be able to have the form values freeze based on the status, which is a combo box on said form. Issue is, when I use what I learned (I learned to set all...

Well stop the press, I did find an answer out there (thank God for the web). When this happens, delete the tables in the front end, and recreate the links from the beginning and it works fine. PHewwwwwwww!!!!

I do, but they are in separate folders. I need a separate backend for the development work, at least I think I do. That said, I started going through them one at a time, and that's when I noticed that it wasn't just one table (the mass update always said the same error about 10 tables into it)...

Hi All, I thought I was done with my application. It was split, encrypted, locked down, nice and tight. I opened my development copy and made some minor updates to a formula (no changes to databases or anything) and also added some text labels on a form or two. So I moved my dev copy (UI and...

Mean to say thanks again. I was doing late binding. But note to self, don't put parens around xl.workbookfunctions :)

Thanks. I was creating the excel application already, and it works fine for other functions, it just doesn't work for certain functions, and I don't know why. The functions work in the excel app. I redimed the excel app as an object and that didn't resolve the situation. I didn't go as far as...

Hello Access Fans, I know this has been discussed before, and I searched the forum last night and was unable to resolve my issue. Hopefully there is an answer out there. I have an access application (developed in access 2013) that includes function calls to an excel application using the...

After reading, it sounds like once you split a database, the best practice is to create a copy of each for staging and remap them, but in the end, there is no real need to unsplit the fe and be once split, unless you plan on distributing the application that way to begin with. Is that right?

Hi, I am running windows 2010 and have Access 2013. I need to encrypt my database, but nowhere, and I mean nowhere, can I find the option to open access or the database in exclusive mode. The file is not shared, maybe that is why, I don't know. Anyway, I selected the encryption option from the...

This issue was solved be eliminating the excel function call and calculating the cell in access.

Thanks guys. I decided to just create my on F statistic table and fieldvalidate the confidence levels to those with F statistics. I will probably try the underscore, but all in all, I prefer to avoid the application calls if possible, even though it reduces the options for the user. I have...

Hey Thanks Rx, Sorry for your long day. I am working all the time trying to build this thing. I have Access 2013 and Excel 2010. Here is the code: Public Function CalcInvTestValue() As Double Dim xl As Excel.Application Set xl = New Excel.Application Dim dx As Double Dim dn As Double Dim...

Hi, I spent all day trying to figure out why sometimes I can call an excel function from access and the value will appear on my form, but for some functions (F.inv, binom.inv), it errors out as "object not supported". I browsed all the available libraries in tools/reference but found nothing...

I have a form that allows the user to pick a record in another database (A) which programmatically populates several other fields including a record type on the upper form (not a split form mind you). In certain record types, there are stored values that are presented on the form in fields on...

Hi All, I created a form that applies conditional formats depending on a field. It works fine, until you enter data into one of the conditionally formatted fields, then all hell breaks loose. Conditional formats totally go away and the cells go to #error. Does anyone know what is happening /...

Thx but I figured it out. Took all night tho