Search results

Greetings all, tina t on utteraccess http://www.utteraccess.com/forum/index.php?showuser=178721 said it clear enough for me to understand. Make the combo box unbound, and then add code in the After Update event to point to the record to be modified. After further digging, I found some references...

This is cross posted here: http://www.utteraccess.com/forum/index.php?showtopic=2028928&st=0#entry2539421 and here: http://www.accessforums.net/forms/update-form-combobox-issues-52687.html Thank you CJ_London for setting me straight.

CJ_London, After many cross posts, no one until now has pointed this out. I will endeavor to do this. Both Access World Forums and UtterAccess are both invaluable resources for me. I recently returned to AccessFourms.net after a very long hiatus. I will properly cross post to the original when...

The button 'CLOSE' buttons are from the Button Wizard, which automatically added the code. Although, I may have added the Me.Dirty line; I need to experiment. I just did and the wizard adds that code. Do you think that line is the culprit? MNM

Greetings, I'm having an issue with two similar forms which change the status of Instructors and Students from 'Atcive' to 'Inactive' with a checkbox, See attached Form Issue ZIP file. Whenever a student's or Instructor's status is changed, the name is written over with the table's ID number...

As replied elswhere: Many thanks! MNM P.S. I bookmarked your website.

Greetings again, For those involved, so far the lesson record BD is running well. However, I wanted to ensure data accuracy for a certain case. I added the unique Student Id (ManabiID) control to the Student Status form (see attached). My intention is to have the ID update to the correct value...

Plog, I slept on it and I think I know where your going. I would need to link the FRM_LessonRecordEntry to a query and not the TBL_LessonRecord. Inside the query would be the eight (8) student references. I've set up the table & relations, see attached image. I'll keep you posted. Mark

plog, Thank you for your input. It gives me hope. Whenever you start numerating field names (e.g. Student1_ID, Student2_ID, STudent3_ID...) its time for a new table to hold all that data. So, I would need to incorporate this into the basic relationship level (to replace the many TBL_Student...

Greetings once again, I created a database to record lesson information (see attached sample). When there was only one student per record, everything worked fantastic. However, management would like to have one record per lesson, which means that up to eight students would need to be accounted...

Gemma-the-husky, I got a good solution from a user on another forum. Dim strPath As String Dim sUserProfile As String sUserProfile = CreateObject("WScript.Shell").ExpandEnvironmentStrings("%UserProfile%") strPath = sUserProfile & "\desktop\PubComExp.txt" DoCmd.TransferText acExportDelim, ...

Greetings, While scrounging around the web, I came across something quite interesting. On http://windowssecrets.com/ the user HansV posted some modules and a form in the thread here; http://windowssecrets.com/forums/showthread.php/111528-GetSaveAsFileName-in-Access-(2003) This allows the user to...

Update: I noticed ":" missing in the code (2 places). Now I get the 3044- invalid path error. Clearly not a solution

Sorry Gemma-the-Husky. In XP w/ A2003, I get: "Compile error Project or library was not want found." The "Environ" was highlighted. Anyone know a Plan B? I ran across this on another site: 'This function is used to allow the use of the Environ function in Access 2003 Public Function...

Yes, the environ("homepath") worked! I need to test it on-site. I read there's a difference between 2003 & 2010; the DB is saved as 2003, but built in 2010. The main workstations will be XP w/2003. If there's no problem, a big Thanks for Gemma-the-Husky Mark

Run-time error '3044': '%userprofile%\desktop\' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. Upon Debug, this line is highlighted: DoCmd.TransferText acExportDelim, , "QRY_ExportPublicComment"...

Greetings, I have a BE database, that when opened, opens a form for saving the results of a query to a text file on the desktop. It works fine, if the full path is entered. The problem is, I want this saved on any users' desktop. I did some digging and found the %userprofile% variable, which...

Greetings, pere_de_chipstick at www.utteraccess.com suggested the appropriate solution. He submitted it in SQL format, but took the intent for the design view I'm used to working in. Here it is: WHERE ((([CourseType])=[Forms]![FRM_Selector]![CourseType])) OR...

Greetings, I have a form on which are two combo boxes. In the first, the user selects a course type. In the second, the user selects the text for that type of course. I've gotten the second control to filter the appropriate texts. The problem lies with the "Private Course". For this case, I...

JHB, Sorry for the late reply; I've been travelling on business. I'm not sure where the "DoCmd.RunCommand acCmdSave" came from. Maybe some code I got from some other post. So, that would explain why the FRM_InstructorInformationLookup doesn't error out. I'll remove the offending lines and try...