Hello,
I could definitely use some help. I'm not even sure if this is possible, but if someone could point out a few options, I would appreciate it.
I would like to be able to email an Access form to someone that doesn't have access to the database (or internal servers). I would like them to be able to open the form, fill in data and be able to send it back. I know I can send a txt file, xls, etc., but I want to maintian...
rousseaud
Last Activity: Oct 27 '11, 09:08 PM
Joined: Apr 19 '07
Location:
-
How to email an editable Access data entry form?
-
Thank youfor the reply, NeoPa. I went back to the table and I did add a numeric field called [RecID] for debugging purposes. I removed this field and everything appears to work.
Thanks again. -
Where in Update Statement Not Working--Updating All Records Instead
Hello,
I could use a little help trying to figure this one out--I would greatly appreciate it.
I'm using an UPDATE statement in VBA to update a table. Typically, this statement should only affect one record. For some reason, it's updating all the records in the table. I'm assuming my WHERE statement is wrong. Here's a short version of the code (all variables in the SQL string are integers:
...Code: -
Creating Records Based on Selecting Specific Results from a Query
Hello,
I need some help/advise about how to tackle an Access problem. Right now, it's kind of a big idea and I would really appreciate any input about how to do it properly.
I essentially want to create a form that queries various records. I then want a user to be able to select various and specific records from the results of the query to create records in another table. I want to have other unbound controls on the... -
Thanks! I'll give a shot.Leave a comment:
-
Auto Fill in a Form by Referencing a Query
Hello,
I hope someone can help. Let me describe my problem. I have a form with a combo box. When I make a selection from that combo box, I want it to reference a query and populate other form fields with that queried information. Does that make sense?
Please help,
David -
Query most recent records for unique field values
Hello-
I'm having a little trouble. I want to create a query that will return the most recent records (by date) for all unique values in a certain field in the query. I'll be pulling data from 3 different tables as well. Since my description is usually inadequate, here's a simple example:
Before Query:
Date Field
1/1/07 A
1/2/07 A
1/2/07 B
1/2/07 ... -
Thanks Steve, that worked brilliantly....Leave a comment:
-
Opening a form to a specific record from a form
I have a continuous form, frmA, that lists certain record fields from tblB. I want to be able to click on one of the records in frmA (just an on click event on one of the form fields) and have that open frmC to that specific record. Does that make sense? frmA references a query of tblB and frmC references tblB directly. I've tried the following in an on click event of one of the fields in frmA and had no luck:
DoCmd.openForm "frmB"... -
Thanks, that was the one thing I was missing. It works great....Leave a comment:
-
In the last line:
"WHERE [ID]=" & Me!Company
how can I have it look for text instead of a number?...Leave a comment:
-
Thanks! I'll give it a shot and see how it goes....Leave a comment:
-
Well, the series of popups will be defined by the user. I'm designing a structure that will point to different popup forms depending on the input from the last. In actuality, I'll have more like 15 popup forms (If user selects A in popup1, it will go to popup5. If I select B in popup 5, I will go to popup 8, etc.). Does that make sense?...Leave a comment:
-
I Hate My Popup Form Problems...Help!
I'm having some trouble getting popup forms to work properly. I have a main form that contains 4 fields that I want to fill in by using a series of 4 popup forms that I initiate by clicking a button. Each popup form has a save button that will save the data and open up the next popup form in the series. Each of the popup forms have a single combo box that looks at various tables to populate date into the main form. The problem I'm having is getting... -
Thanks! This is a big help. I had some trouble with the SQL in the last line and changed it a bit. Here's what I ended up using:
Dim strVar As String, str0 As String
Dim inInt As Integer
strVar = Me!MyBoxP.Colum n(0) & "P" & Me!MyAutoNumb
inInt = Len(strVar)
If inInt < 11 Then
Do Until inInt = 11
str0 = 0 & str0
strVar = Me!MyBox.Column (0) & "P"...Leave a comment:
-
Thanks for the reply. I do have a combo box setup. There is one field beside the ID, called Product. The field in another table that I want to store the Part Number is called PartNumber. I would appreciate any help you could provide. Thanks...Leave a comment:
-
Generating a Part Number
I’m trying to generate a part number of sort. It must be a total of 11 characters and have two “sections” separated by the letter ‘P’. The first section is a number I select from a combo box and can consist of 1 to 6 characters in length. The second section must be a unique incremental number starting from 1 that will have leading zeros to make up the total 11 character part number. It would look something like this: 0000P000000. Any help?
No activity results to display
Leave a comment: