Search results

Thank you CJ for the info So there is now free option on having you access DB saved on the cloud available for sharing? At this point in time we are a 3 members in our new company, so having a dedicated server an all to assess via a network is a option but the issue comes in when i need to...

Hi all, I know that Access does not play along very well when saved on the cloud for sharing I am in a bit of a predicament, as I don't know how to do a fully functional program in Excel and as Google sheet is a awesome platform for sharing, I don't know how to do a fully functional program in...

Thank you Looks great

Hi all, Hope all is well I want to highlight when the requirement date is less then 6 days from now I used the below conditional formatting formula but not working as I thought it would

This is a temporary file so should be ok but thank you for the advise One record at a time

Thank you

Hi all, I want to replace all records with a "-" to no spaces starting with AS350A AS35A012-345-78 to AS35A01234578 Please advise ho to use like with a replace statement

If no date then the result should be a blank

I am having the same issue with below Not sure where to add the NZ

Hi all, I am getting an error on my code and assume it could possible by because i am only looking at Chr10 and not including Chr13 So I replaced with below code When the control is blank, I get an error calculation

Hi all, Please could you advise how to continate the following If Type = Airframe, then no Serial number selected, I only want to see the Airframe records If Type = Engines, then Serial number is selected, I only want to see the Engine records with the selected serial number

Hi Arnelgp How would I convert the code to only look at 2 controls with an " - " should the second control have any data? I tried

Hi all, Has anyone come across an easy way of centering a check box? when a check box is created, it is aligned top left of the orange block and not centered with the label I then remove from layout to center or manually create the check box without a layout

Got it Did the trick

I was looking at Replace but not sure how to check for character 13 I believe it was created with carriage return in the string

Hi all, I am importing from excel The part number field may have multiple part number Then you open it in excel and wrap the text, you can see the part number in separate line In access, it is one long string with no separators Please could you advise how to have these part numbers separated...

Works like a charm Thank you

:);)

Ok, I will avaid using descripyion in the future The query worked before but now after using Column I get the Undefined function Any work araound?

I used the Column() property Getting a Undefined function error