Hi NeoPa,
Sorry my question wasn't clear. I figured out what I was doing wrong. I needed to take a break to clear my head. Thanks for replying back.
Umoja
Last Activity: Jan 15 '08, 04:51 PM
Joined: Nov 14 '06
Location:
-
-
Importing excel spreadsheets without defining table
Hi All,
This seems like a simple thing, but I can’t seem to figure it out. I am familiar with transferring excel spreadsheets into access using the TransferSpreash eet function Ex:(DoCmd.Trans ferSpreadsheet acImport, 8, "LogTemplat e", "C:\Documen ts and Settings\My Documents\Log template.xls", True, "").
I would like to import several spreadsheets into access without creating the table.... -
Thanks nico5038 for all your help.Leave a comment:
-
Access 2003: Update table field
Hi Guys,
This is a follow up question from my previous post which Nico5038 help me solved. I have a tblMain which contains (ID-Autonumber, Acct, Number, User). TblMain currently does not have users listed/assign.
I have TblUsers (ID, UserName). From TblMain I created a query (Qry_Distributi on) which allows me to distribute the accounts evenly among 4 users.
I would like to know how to update the [User] field... -
Hi nico5038,
Thanks for the input, I wasn't familiar with MOD statements but did some reading on it and I was able to figure it out. Thanks again for your guidance, you guys are great!Leave a comment:
-
Hi Jason,
I don't understand completely the system your are trying to build but try the following. In the query under the date field, in the criteria enter
=Date() + 1
Hope this helps.Leave a comment:
-
Access 2003: Even distribution
Hi All,
I was wondering how do I evenly distribute a list of accounts among 4 users. I understand based on the number of records it is not always going to be evenly distributed. Is there a statement that can be entered in the criteria of a query. I originally did it by alpha split but that doesn’t work that well. Thank you for any suggestions. -
Hi Mary,
Thank you for your input. I did not think of setting up user login, which would probably be the easiest. Thank you for the advice.Leave a comment:
-
Access 2003: Distributing App
Hi Guys,
I just complicated my database and I wanted to know what is the best practice for staff to access the APP. I have split my DB in 2. The back end stores the data and the front end is the App. The database will be placed on a network drive. In my DB I have 4 different forms, there are 4 different staff using the DB. Each have different task to do which is why I had to create different forms. The best way I thought for distributing... -
Thank you, mmccarthy I made a few changes and I was able to get it to work.Leave a comment:
-
Hi mmccarthy,
Sorry for not explaining everything clearly. The control source of cboStatus is not set to the relevant field. This is how I have everything setup. The source for the form is a query [Custdetail]. The source for this query is the main table [Tblcustinfo] which contains all the fields. One of those fields is a text field called [CS], by default this field is set to N. Once a selection is made from the combo box [cboStatus],...Leave a comment:
-
Changing field value
Hey Guys,
Hopefully there is a simple answer to this question. Currently on my form I have a combo box [cboStatus]. The selection from the combo box is open, close, review etc. Once the selection is made from the combo box it assigns it to the account and insert the information in another table. The users do have access to the accounts on the form by a filter. I am using the Docmd.Run my Sql function to insert the information into... -
HI guys,
Thanks for all your help, it worked perfectly.Leave a comment:
-
Refresh form
Hi Guys,
I need for one of my form to refresh after a selection is made from a combo box. On my main table I have a status field which the default value is set to ‘No’. Once the selection is made from the combo box the status of the account is changed to ‘Y’. I have an update query which updates the status once the selection is made. The main source for the form is a query, in the query I have the criteria to only display... -
Thank you MSeda, I was able to do it in the event procedure. Thank you very much.Leave a comment:
-
Macro action: RunSql
Hi guys,
Currently in my DB I have a macro to run an Sql action, I am using the INSERT INTO function. Everything is working fine but I wanted to increase the number of fields that is being entered into the table. In Access the run sql action only accepts up to 256 characters.
I decided maybe it can be done by setting up 2 RunSql actions. The problem I am having is the second RunSql action is not entering the data on the same... -
Thanks PEB for all your help. I think I got it.Leave a comment:
-
HI PEB,
Thanks for replying, you have to forgive me but my vb programming skills is not good at all. Please be patient with me. I enter the code below into the AfterUpdate event of the combo box but it did not work. If you coud please look at it and tell me what needs to be changed.
Private Sub cboOption_After Update()
DoCmd.RunSQL "INSERT INTO Tbl_Analysis(AC CT#, PTName, PTFNCLS, Activity_code)...Leave a comment:
-
Append query
Hi guys,
Hopefully I am not asking for to much here. On my main form [Patients], its source is from a qry [Qry_All_Patient s], which is created from table[Tbl_All_Patient s]. I would like to add a combo box [cboOption] which has 2 choices. They are review & completed.
Is there a simple code I can enter in the AfterUpdate of the combo box which will append the [Acct#, PTname, PTFNCLS] from the main form to a table.
... -
That actually made sense to me, Thank you very much.Leave a comment:
No activity results to display
Leave a comment: