Hi Z.
Yes I have, but not in code. I used set the controls on Data tab of the Properties sheet of the list box to "Yes" for AllowValueListE dits and "No" for LimitToList.
I have a few list boxes that require editing by opening a form that feeds into their record source. In this case, Client Name is edited at the List of Clients form. The list boxes that I opted out of this have a less significant value,...
Shem K
Last Activity: Jul 31 '15, 11:43 AM
Joined: Apr 21 '15
Location: Nairobi, Kenya
-
Hi Rabbit. Thank you very much for your suggestion.
That's a viable option. However, I'm at the very shallow end when it comes to writing VBA. I however managed to look into another option.
I followed the procedure in the MS Access 2007 Help article "Customize the Ribbon" and managed to hide the crucial tabs while my list boxes remain editable.
Please see Microsoft's link:
https://su...Leave a comment:
-
Shem K started a topic Making list box editable after unchecking "Allow Full Menus" in Access optionsin AccessMaking list box editable after unchecking "Allow Full Menus" in Access options
Hi guys.
On a pilot run, a user pointed out to me that they could not add items on a list box. Usually, I set my list box Limit To List data control to "No" and and Allow Value List Edits to "Yes", to allow the users control over the list items. However, these options are unavailable when I uncheck Allow Full Menus in Access Options (A practice that helps keep users from other Access menu items that would cause... -
Access referencing data from Outlook Calendar
Hi guys.
This is a converse to the discussion in this link, with focus on post #5 and #6:
http://bytes.com/topic/access/answer...scheduled-date
I'm doing some research on it online at the moment. If I'm unsuccessful, I'd let the database work with Outlook automation, as per the solution in the above thread.
Kind regards,... -
Thanks Seth.
I'm creating a new thread on this right away.Leave a comment:
-
Hi guys.
I generally had a busy month, working on other sections on my database. I did manage to generate a form (hoping it wins some approval). Something I noted this morning is the calendars (Google and Outlook) won't sync until Outlook is running. I created a Message Box macro, notifying a user to run outlook for the two calendars to be synchronised.
Just a thought: how can Outlook calendar be conversely used to update...Leave a comment:
-
Using file path links instead of document attachments
Hi guys.
I'm referring to the insight by Rabbit on this link: http://bytes.com/topic/data-manageme...external-media
and by jforbes on this link: http://bytes.com/topic/access/answer...i-attachements
I made a dummy database with attachments and realised attachments could take up too much space, as compared to the actual data. This inevitably would... -
Hi NeoPa. The table does exist in my database. I did counter-checked the spelling severally, and the name is intact.
I thought it was probably the underscore present in my call events that made the code not recognise the table. I removed the underscores (to read "List of Matters Audit temp" in place of "List_of_Matter s_Audit_temp"), but this brings a syntax error.Run-time error '3131':...
Syntax error in FROMLeave a comment:
-
Hi guys. I trust you had a great weekend.
Hi Z. The string value on the Immediate window (Ctrl+G) is:
Code:DELETE FROM List_of_Matters_Audit_temp;
Leave a comment:
-
Sorry. I thought it was the one in the VBA.
It's clearer now. Navigating to the sSQL code is all new to me. I'll kindly need your help on doing it please, especially in unraveling that statement, as, in light of what you have just pointed out, I don't know which SQL it's referring to.Code:db.Execute sSQL
Again, I apologise for my newbieness :(Leave a comment:
-
Thanks for the link Seth. I'll look into the Microsoft Guide shortly.
---
Z, yes they are. And are able to manipulate events from Google calendar, with changes reflecting on their Outlook Calendar. The converse also works (I ran a test on it with my work account).Leave a comment:
-
This makes a lot of sense. I'm updating my code with this one. Thanks NeoPa.Leave a comment:
-
remote notification on google calendar from access scheduled date
Hi guys.
The above refers, and came as a request from my clients (one of the organisation's Partners for which I'm developing the database).
Background: the Firm had synchronised their Outlook accounts with Google, thus any update they make on their Google accounts is reflected on Outlook. Now, I'm looking at a way to link up a date field to Outlook Calender, and this consequently updates their Google calendar. This means they'll... -
Hi guys.
Just an addition: I did a follow-through on the DoCmd.OpenForm on this one and recently (this morning) converted the macro events of a few forms from a copy of my project into VBA. In Access 2007, the code line for the Where Condition looks like this:
...Code:DoCmd.OpenForm "Paul: Matters in Detail", acNormal, "", "[File Ref]=" & "'" & [File Ref] & "'", , acNormal
Leave a comment:
-
Hi NeoPa.
Please see from line 8.
I included the previous code that relates to it:
...Code:'Remove any cancelled update still in the tmp table. Set db = DBEngine(0)(0) sSQL = "DELETE FROM " & sAudTmpTable & ";" db.Execute sSQL 'If this was not a new record, save the old values. If Not bWasNewRecord Then sSQL = "INSERTLeave a comment:
-
I've included an Autonumber field (field name File_ID) into my List_of_Matters table, and reflected it into my sample form and respective form events for auditing. After compiling and testing data, I get this error:Run-time error '3078'(List_of_Matter s_Audit_temp is my...
The Microsoft Access database engine cannot find the input table or query 'List_of_Matter s_Audit_temp'. Make sure it exists and that its name is spelled correctly.Leave a comment:
-
Hi Z. I trust your weekend was great.
Wow. I didn't know that. I guess I'll need to omit the code. Had hoped that it would include alphanumeric values too. Thank you for taking me through it, though. I'll keep this code to use in case I land another Access/VBA-based assignment.Leave a comment:
-
Me.File_Ref has alphanumeric data based on the filing system, and it uniquely identifies all other fields in the record.
I've changed its data type to Text instead of Memo on the table's design view. I've also included the CLNG () type conversion, but I'm getting the same error message.Leave a comment:
-
1) Me.File_Ref is a text field (specifically, a Memo field).
2) I've declared the Boolean data type as you've suggested above. Still, the Type mismatch appears at my Call AuditEditBegin line.Leave a comment:
-
Thanks for your great help in taking me through this one, gentlemen :-)Leave a comment:
No activity results to display
Leave a comment: