Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.06 seconds.
Search: Posts Made By: SOS
Forum: Modules & VBA 07-23-2013, 02:02 PM
Replies: 20
Views: 1,095
Posted By SOS
Re: Search Form & Error Messages

Oops, sorry. Remove the Exit Sub from each of the Case statements. I forgot and left those in there.
Forum: Modules & VBA 07-23-2013, 01:23 PM
Replies: 4
Views: 2,275
Posted By SOS
Re: Active X Monthview Control 6

Is your control visible when you try to set the value? It needs to be. I just got the same error if I set its visible property to NO.
Forum: The Watercooler 07-23-2013, 01:11 PM
Replies: 20
Views: 1,639
Posted By SOS
Re: free back end server

Dick:

He's telling you that she, using that computer she currently has, can connect to her own computer at home directly by using Remote Desktop Protocal (RDP). Read this to find out how:...
Forum: Modules & VBA 07-23-2013, 01:09 PM
Replies: 4
Views: 2,275
Posted By SOS
Re: Active X Monthview Control 6

What version of Access are you using? I tried it in Access 2007 and this worked:

Me.MonthView3.value = Date

(my control is named MonthView3)
Forum: Modules & VBA 07-23-2013, 12:12 PM
Replies: 20
Views: 1,095
Posted By SOS
Re: Search Form & Error Messages

I've fixed it and have combined the two searches into one. Post back if you have questions. I took the input mask and validaton off. Those aren't good for searches.
Forum: Modules & VBA 07-23-2013, 11:26 AM
Replies: 20
Views: 1,095
Posted By SOS
Re: Search Form & Error Messages

I suggest uploading a copy of your database (with bogus data) so we can see what is happening. If you do remember to run Compact and Repair first and then ZIP the file before uploading.
Forum: Modules & VBA 07-23-2013, 11:05 AM
Replies: 20
Views: 1,095
Posted By SOS
Re: Search Form & Error Messages

You still didn't get it.

If DCount("*", "tblUser","[PayrollID] LIKE '" & Me.txtPayrollIDSearch & "*'") > 0 Then
Forum: SQL Server 07-23-2013, 10:14 AM
Replies: 3
Views: 989
Posted By SOS
Re: #Deleted

The problem is Access doesn't like BigInt. Have you tried using the SQL Native Client 10 ODBC driver?
Forum: Macros 07-23-2013, 10:07 AM
Replies: 1
Views: 1,800
Posted By SOS
Re: Help: Create Macro: Echo Action

Add an Action of DoEvents before this step.
Forum: Modules & VBA 07-23-2013, 10:00 AM
Replies: 3
Views: 516
Posted By SOS
Re: Errors caused by not using linked tables?

You wrote:

Forms!Referrals!Paycode = str_Paycode

But where and what is str_Paycode? Is it a variable? If so, does the form Referrals have the field Paycode in its record source and you...
Forum: Queries 07-22-2013, 02:53 PM
Replies: 10
Views: 4,428
Posted By SOS
Re: Linked Table Date is Text

Your first query is correct but an Input box returns TEXT so you have to encapsulate that in the CDate as well.
Forum: Modules & VBA 07-22-2013, 02:49 PM
Replies: 7
Views: 1,696
Posted By SOS
Re: Trying to split a dashed number into multiple columns

Interesting way to get the output from a single function call. Never seen that done before like that. But my normal way is to make it more reusable so that it matters not how many parts you have. ...
Forum: Tables 07-22-2013, 02:38 PM
Replies: 5
Views: 3,187
Posted By SOS
Re: Using NZ in a table calculated field

Yes, that is true about the SQL Functions. And, while the 2013 Web databases are more functional and can create more complex ones than one could in 2010, they are seriously limited. I wonder if MS...
Forum: Modules & VBA 07-22-2013, 02:18 PM
Replies: 5
Views: 1,772
Posted By SOS
Re: VBA Code for Ticking Checkbox if Field Entry is Found in Another Table

Gary - looks like you are missing a slight bit of code to move next.

rs.MoveNext

otherwise it will just hang there on the one record and be in an infinite loop since it will never get to the...
Forum: Tables 07-22-2013, 02:15 PM
Replies: 5
Views: 3,187
Posted By SOS
Re: Using NZ in a table calculated field

The one problem with Web databases are that you need to use calculated columns essentially because there are things they can't do which one would normally do otherwise. I don't use web databases so...
Forum: Tables 07-22-2013, 02:07 PM
Replies: 18
Views: 1,139
Posted By SOS
Re: Fields not reading the same

Maybe this will help:
http://www.btabdevelopment.com/ts/removelookups

You don't need to start over really but you shouldn't be working directly in tables anyway. You should have forms for the...
Forum: The Watercooler 07-22-2013, 01:43 PM
Replies: 15
Views: 1,379
Posted By SOS
Forum: Tables 07-22-2013, 01:41 PM
Replies: 18
Views: 1,139
Posted By SOS
Re: Fields not reading the same

I would not use lookups directly at table level if you are doing so. It would be best to use lookups at form level. Here's a link to more about why:
http://www.mvps.org/access/lookupfields.htm
Forum: Forms 07-22-2013, 12:58 PM
Replies: 4
Views: 637
Posted By SOS
Re: Two Forms; One Field

Just open the other form like this:

DoCmd.OpenForm "FormNameHere", WhereCondition:="[SSN]=" & Me.SSN
Forum: Tables 07-22-2013, 12:56 PM
Replies: 18
Views: 1,139
Posted By SOS
Re: Fields not reading the same

If you delete data from linked tables, then that same data will be gone for everyone else, but only you know whether that is a problem for you as we don't know your business, etc.
Forum: The Watercooler 07-22-2013, 12:54 PM
Replies: 20
Views: 1,639
Posted By SOS
Re: free back end server

SQL Server 2012 Express is also free.
http://msdn.microsoft.com/en-us/evalcenter/hh230763.aspx
Forum: Queries 07-22-2013, 12:52 PM
Replies: 2
Views: 2,901
Posted By SOS
Re: Access freezes when switching to design view in open query

You can't open a SQL query with 5055 characters in design view (which is what you have). It is limited to ~1500. After that, you only get SQL View.
Forum: Tables 07-22-2013, 12:50 PM
Replies: 18
Views: 1,139
Posted By SOS
Re: Fields not reading the same

Is that backend table showing as a linked table in the frontend and is that what you are looking at when you open the frontend? Or are you maybe looking at two different tables. From your...
Forum: Queries 07-19-2013, 07:55 AM
Replies: 7
Views: 3,562
Posted By SOS
Re: Table: Too many fields defined.- To Normalized Tables

See if this helps:
http://r937.com/relational.html
Forum: Queries 07-19-2013, 07:48 AM
Replies: 3
Views: 738
Posted By SOS
Re: Pulling Records based on blank/nonblank criteria

A bit of a reminder - fields might be NULL or an empty (zero length) string so it really depends on what is allowed in that field. If it can be either Null or an empty string, you could just create...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 07:50 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World