Search results

Hi all, I have spent the better half of the afternoon researching how to accomplish controlling a bold font in a string I am building and sending to Excel. ' set text for safety hazards and controls Concretetxt = "Concrete Demolition & vbCrLf & Hazards - dust, flying debris and skin Irritation...

Hi all, This should be relatively easy although I seem to have forgotten a lot since the last database I completed. I have looked through several examples online and I am lost. :confused: On my form frmEmployeeDetails I have a text field that is named SSN for social security numbers. I have...

I did manage to figure it out, sometimes I over-think it!;) Private Sub Form_Current() If Nz(Me.Address, "") = "" Then Me.Address = "Street Address" Address.FontItalic = -1 End If End Sub

missinglinq, Code is great! Exactly what I want although is there some modification to the font or color of it? I would love this to populate in Italics just for cosmetic reasons to make it stand out. I searched yesterday unsuccessfully trying to find some code examples that I could implement...

Thanks for your suggestion Julian, It did not make a difference in the view. I did reach out to support to investigate and will update the post with new information. What ever the problem is- it is affecting iPod 5g, iPhone 5g, iPhone 6 plus but not the iPad or mini.

Jessica, I think that instead of using the import & link option you should use move data under the Database tools then it will give you the option to select which tables you'd like to move. Samantha

HI, I would suggest downloading a trial version of Access and signing up for a trial of Sharepoint and playing with it. You would have to have an on premises sharepoint server to use your own - otherwise you have to use the online service @ 12.95 per user per month - billed annually otherwise...

Hi All, So, I have purchased the new Access 2013 with the intention of creating a web app to share details with field employees. I have signed up with sharepoint for a trial to see if I can accomplish my intention before paying monthly subscriptions. Right off it seems easy enough although my...

Moore, I am no expert with Sharepoint, I am just starting to figure it out but I did read somewhere that there is no VBA on Sharepoint versions ran through your browser. It is macros only. Unless you are using a split database with a desktop front end and linked to tables hosted on Sharepoint...

MarvinM, Could you post your code to the thread? Pretty please! Thanks, Samantha

Thanks for your time Bob, I did rebuild it by changing the query to include the field I wanted as an expression instead of completing it in the form itself. No idea why it stopped working. :)

Thanks for your reply Bob, I have a text field that is a expression combining two pieces of data. The previous code is just what is behind the form itself and should have nothing to do with the issue (only for info purposes). The field in question is set by the expression builder as... Control...

Hey Bob, I am having essentially the same issue in Access 10' only mine is based on an expression. The form itself is a split form and has the following code: Private Sub Form_Open(Cancel As Integer) Auto_Header0.FontName = "Impact" End Sub The funny thing to me is that it was working fine...

I ended up figuring the problem out I was missing a space in between the quotes where the underscore now is. .Start = Nz(Me![Pre-BidDate], "") & "_" & Nz(Me![Pre-BidTime], "")

Update: So I went back and changed the table for the field in question to a Date/Time field formatted as Medium Time and now I am receiving an error message "Run time error -2147352571 Type Mismatch: cannot coerce parameter value. Outlook cannot translate your string." :confused:

Hi all, I am using a windows 7 64-bit operating system with Access 2010. I have the following borrowed code attached to a button on my form that sends the meeting to my calender and invites others to the appointment. There is a error being thrown at .Start the date goes in correctly however the...

Re: Is there anyway to restrict users to hide&rearranging the columns in Datasheet vi Well, I am sure they have come up with some sort of solution by now. I was just attempting to help :banghead: I could have sworn it said they were working on a datasheet form that was a split database with the...

Re: Is there anyway to restrict users to hide&rearranging the columns in Datasheet vi However, by forcing the form to close without saving and not prompting to save then it would reset itself to the original design and it wouldn't matter it they sorted or hid anything. Although I am not sure...

Re: Is there anyway to restrict users to hide&rearranging the columns in Datasheet vi By turning off the warnings you avoid the application asking if you would like to save design changes. That is what I have set my navigation form to, on my datasheet form I have it set on the current event to...

Re: Is there anyway to restrict users to hide&rearranging the columns in Datasheet vi I have accomplished this even though each of my users are on their own front end. My datasheet form is inside of a navigation control which only has two options the datasheet and another general form. See...