Search results

Hi The_Doc_Man, thanks for that reply. I'm getting a bit confused over this WiFi data corruption business. So if using products like Caspio , are you suggesting a LAN and router or to just have the database in-house and not connected to the internet at all? How is it that the data is corrupted...

Hi Pat, I'm not sure I understand completely when you say shared drive, let me explain what Ive done so far and that might help me to understand. I have created a VM in AWS, Amazon give you many options and provide different platforms/services. For the database Ive created a Virtual Windows 10...

Hi , I am trying to put a front end database on a laptop with MS Access 365 installed on the machine but when I put the front end on the desktop I get the message below. Ive had googled and tried a couple of things but they havent worked. Has anybody come across this before. Error message...

Yes thanks for that. The WiFi is unstable here Ive discovered - the connection seems unpredictable. So Ive been asked to look at Amazon. From what Ive seen Amazon provide an RDS instance ( allows the user to create an environment for a relational database), however it doesnt seem completely...

Hi, Has anybody any advice as to how I might go about this please. I work in an office with no local network, all the machine are laptops (apart from my desktop). Ive created a database in MS Access that sits on my desktop. Ive split the database into front end and back end and would like to...

Thanks Arnelgp for this its a big help

Thanks for that Pat - what is DS view ?- have you got a simple example of what you mean please

Hi all, I have a search text box that sits above a nav form, so when I enter a value in the text box and click the button the value is found in the form. But how do I continue to search for the same value starting, again, from where the first occurrence has been found in the form. Ive tried to...

Hi - its the Microsoft Server Express Edition. Ive created an RDS instance but trying to see how I upload the database to this

Hi everybody, Has anybody any experience of migrating an MS Access database to the cloud to using Amazon AWS? Ive been asked to do this with the database Ive built. Ive created an RDS instance following their guidance but found the rest of the documentation is way over my head. Has anybody...

Hi The_Doc_Man - its the Access version with Office365

Sorry I'm a bit confused with the syntax the macro gives me ="[fldCaseNumber] = " & Str(Nz([Screen].[ActiveControl],0)) so this line becomes "SELECT fldCaseNumber FROM tbl_Data_LOI_Instructions WHERE fldCaseNumber = & Str(Nz([Screen].[ActiveControl],0))", dbOpenSnapshot, dbReadOnly) but I'm...

Thanks Pat - I think the database needs redesigning, table1 just accumulates rows when the user enter the name address etc for a person and this gets assigned a PK for this person. Once this person has been created with this PK a certain action can occur. This table then looks to see if this REF...

Hi, I have this code that works and tells me lets me know if a number exists in a field. So txtFindNumber say 1234.001 exists in the field 'fldNumber' - but I need to bookmark the once its found so the user can edit it - how would I do this please? Ive had a look at the doc.microsoft page and...

Thanks Saphirah for that reply, the problem that I have is that there are some fields I may need to keep, so if a delete all the record and use replace I will lose all that data. But could I just delete the PK and then use the INSERT statement ? would this still insert in the same record?

Thanks, Sorry I'm just catching up with these replies. Basically I have 2 tables (table 1 and table 2) that accept data from 2 different sources at different times. So for example table 1 might have patient data and table 2 medical information. The first table uses a unique identifier created by...

Hello everybody, I have a script using Python that uses the INSERT statement to input data into a table, using something like the test statement below cursor.execute(' INSERT INTO tbl_test (fld_PK, fld_value1, fld_value2) VALUES (?,?,?)'),(ID, name, address)) This wont work if I have a...

Thanks I’ve changed it to what you suggested - it makes more sense!

I’ve recreated the email in access previously with names / addressesbut couldn’t get a checkbox for recipient verification on confirming they understand terms/conditions - I will try the rich text long field for the check box- thanks. If that doesn’t work will see if there is a different...

Hi Gasman, how would I do that in outlook? Is there a simple example, sorry I’m new to this. I’ve recreated the email in access in vba with names/addresses the problem I then have is trying to recreate the text box for the recipient to agree. If I do it the other way so I have a template with a...