Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 32
Search took 0.00 seconds.
Search: Posts Made By: sloaner14
Forum: Forms 08-13-2007, 08:58 PM
Replies: 1
Views: 549
Posted By sloaner14
Add/Change and Delete

I am tired of trying to figure this out, so I humbly ask for assistance. This may be so simple. I have a procedure that will append a record with New, Edit, or Delete depending on the event. I have...
Forum: Modules & VBA 04-27-2006, 03:33 AM
Replies: 2
Views: 615
Posted By sloaner14
Life Saver

Thanks a million!!! I was ready to pull my hair out. I knew that it was something in my data type, but could not figure it out. I tried cdate and everything I could think of, but I never used...
Forum: Modules & VBA 04-26-2006, 08:37 PM
Replies: 2
Views: 615
Posted By sloaner14
Combining 2 dates to make 1 date

Why does this not work for me?:confused:

I get r-t error '13': Type Mismatch

*** datDate is from a DAO.Recordset rs!LastUpdate ***

NewDate = Month(Date) & "/" & Day(datDate) & "/" &...
Forum: Forms 01-18-2006, 09:08 PM
Replies: 4
Views: 905
Posted By sloaner14
Thanks for looking, but I created a place field,...

Thanks for looking, but I created a place field, and used some vba and sql to renumber the fields for me.
Forum: Forms 01-18-2006, 08:18 AM
Replies: 4
Views: 905
Posted By sloaner14
Here is a jpeg of what I want. Thanks, for...

Here is a jpeg of what I want. Thanks, for looking at it.
Forum: Forms 01-18-2006, 05:44 AM
Replies: 4
Views: 905
Posted By sloaner14
Plain and simple: Is there a way to have an...

Plain and simple:

Is there a way to have an unbound text box, in a continuos form, that will show the record number of each record in that form. The record at the top of the form will be 1, the...
Forum: Forms 01-17-2006, 09:35 PM
Replies: 4
Views: 905
Posted By sloaner14
Race Finish Place

Is there an easy way of doing this? I have a database that I want to automatically place racers as they finish. I have four race divisions. All racers no matter the division start at the same time. I...
Forum: Queries 12-20-2005, 12:48 PM
Replies: 3
Views: 675
Posted By sloaner14
Never mind, I finally got my SQL statements right...

Never mind, I finally got my SQL statements right and the Loop that I need. As always, thanks for your help.
Forum: Queries 12-20-2005, 10:56 AM
Replies: 3
Views: 675
Posted By sloaner14
Here is what I am trying to do. I have a table...

Here is what I am trying to do. I have a table called tblMailingList. It is made up of records from two tables. I can do that. Where I have a problem is, I have some customers the get multiple issues...
Forum: Queries 12-19-2005, 11:17 PM
Replies: 3
Views: 675
Posted By sloaner14
Question Append Same Record

I know when you see these you will think, "What are you doing?" So, I will tell you. I have to append certain records to another table multiple times. I have a field that stores the number of times...
Forum: Tables 10-26-2005, 12:33 PM
Replies: 1
Views: 840
Posted By sloaner14
Combine records

I need to know how to combine two records. What I have is a text file that is imported into a table. The problem is, the text file has 4 fields on one line then 3 fields on the next line. Is there a...
Forum: Forms 08-03-2005, 05:36 PM
Replies: 2
Views: 2,601
Posted By sloaner14
Cool Cancel form close event

Is there a way to cancel a form's close event? If a user clicks the form's close button, I want a msgbox to ask if they are sure, and if yes continue and close, else cancel the forms close event. I...
Forum: General 07-06-2005, 10:41 AM
Replies: 1
Views: 1,608
Posted By sloaner14
Cool Backup BE Database

I recently created a database with an FE and BE, and I want to be able to back up the BE from the FE. In the FE, I added a menu item "Back up database...", and it works good for the FE, but I want it...
Forum: General 02-09-2005, 01:02 PM
Replies: 3
Views: 651
Posted By sloaner14
Thanks for the reply. I have never done a...

Thanks for the reply. I have never done a dbsnapshot. Any hints on what to do.
Forum: General 02-09-2005, 11:45 AM
Replies: 3
Views: 651
Posted By sloaner14
Cool Data from previous record

I have your standard customer, order, and order details database. In tblOrders, I have the the shipping address information. The reason it is in orders, a few clients can ship to different addresses...
Forum: Modules & VBA 05-21-2004, 05:51 AM
Replies: 1
Views: 713
Posted By sloaner14
Exporting to text file

When using the docmd.transfertext delimited, how do you make it delimited with a space? Also, is there a way to format the number fields to a #.00 format before doing this?
Forum: Modules & VBA 04-15-2004, 10:30 AM
Replies: 16
Views: 2,312
Posted By sloaner14
I understand the issues with size, but this what...

I understand the issues with size, but this what the client wants. What you have done is perfect, I just need the other information in the attendance table. If I try to explain the maddness, it may...
Forum: Modules & VBA 04-14-2004, 01:07 PM
Replies: 16
Views: 2,312
Posted By sloaner14
RichO, this is exactly what I am looking for, but...

RichO, this is exactly what I am looking for, but I need it to append to tblAttend. I got it to do that, but I can only get it to append the dates. I need it to append the SSN, cboActivity, txtBTime,...
Forum: Modules & VBA 04-14-2004, 05:22 AM
Replies: 16
Views: 2,312
Posted By sloaner14
I guess the format is wrong. Date should be short...

I guess the format is wrong. Date should be short date and Time should be short time. The unbound controls at the top are just holders for the user to type in the Activity, BDate, EDate, select the...
Forum: Modules & VBA 04-13-2004, 09:40 AM
Replies: 16
Views: 2,312
Posted By sloaner14
I have been off all weekend. I will try the code...

I have been off all weekend. I will try the code you posted, but I also threw together an example. I too am green to vba, I have code that will work, but it is huge. I know there is an easier way. I...
Forum: Modules & VBA 04-09-2004, 04:10 PM
Replies: 16
Views: 2,312
Posted By sloaner14
Damn I can type today.

Damn I can type today.
Forum: Modules & VBA 04-09-2004, 04:09 PM
Replies: 16
Views: 2,312
Posted By sloaner14
Sorry, I should tell me reasoning for this. I...

Sorry, I should tell me reasoning for this. I work at a school, and I get the job of building db's. I buidling one for a program that wants to be able to track all their students. It going to work as...
Forum: Modules & VBA 04-09-2004, 04:06 PM
Replies: 16
Views: 2,312
Posted By sloaner14
Exactly, I guess I just didn't know how to ask...

Exactly, I guess I just didn't know how to ask that.
Forum: Modules & VBA 04-09-2004, 03:19 PM
Replies: 16
Views: 2,312
Posted By sloaner14
I have a table, and form built. What I have is,...

I have a table, and form built. What I have is, two text boxes to allow the user to enter the Begin Date and the End Date, I also have check boxes that allow the user to select the days of the class....
Forum: Modules & VBA 04-07-2004, 01:07 PM
Replies: 16
Views: 2,312
Posted By sloaner14
Date Scheduler

I am trying to figure out a way to schedule date. I need to be able to have a begin date, end date, time, and check boxes to select the days of the meeting. I basically want to take a student, put...
Showing results 1 to 25 of 32

 
Forum Jump



All times are GMT -8. The time now is 07:51 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