Search results

Understand, thanks. Are there tools to export table relationships from MS Access?

I can not force my client to install anything. Are there other solutions?

I've built a project in MS Access, however client don't have it installed on its PC. Is there a way to move it to web application, so client will simply log-in to work with it (w/o any installations on his end)?

Having a table with tens of records: Honda, Toyota, Lexus, e.t.c Required to create a table for each record and to link ID of each table to that record. Could this be done in a code?

Thank you, plog! I will try this out!

Correct, checkboxes indicate which question(s) should be generated based on what the user selects. What would be the table names , what would be the values within those tables , how the tables would be linked?

I will try better to explain, sorry for mess. User may enter car category or color or fuel type or all of them together.. This will generate a questions. For instance : 1. User selected fuel type = 93 octane ==> was generated a question of "trunk volume" 2. User selected color = black ==> was...

Guys, need your kind help to implementing tables and relationships of a shown logic, where horizontal selections generate vertical questions.

Re: Error "The record source '|' specified on this form or report does not exist" By connection I mean to connections between tables. Some of the tables disappeare with sending the file as well as the connections. To make story short, the file arrives not as it sent.

Re: Error "The record source '|' specified on this form or report does not exist" The database was not split, however somehow after sending by email not all tables arrive..

Re: Error "The record source '|' specified on this form or report does not exist" Sorry for confusing, the tables are lost while sending file by gmail.

Re: Error "The record source '|' specified on this form or report does not exist" I've checked the issue on customer side and found that during sending the DB by email some of the table and the connections got lost?! Tried to archive and then to send, got same issue. Does it make sense?

Error "The record source '|' specified on this form or report does not exist" Same file works smoothly on my PC , but certain tables throw errors on customer side. Have anyone faced that error, any thoughts?

Thank you for challenging me, I did it this way and that works too! UPDATE tbl1 SET tbl1.myDate1 = #12/12/2012# WHERE tbl1.myDate2 =(SELECT Max(tbl1.myDate2) AS MaxOfmyDate2 FROM tbl2 INNER JOIN tbl1 ON tbl2.ID = tbl1.ID GROUP BY tbl2.EmpID HAVING tbl2.EmpID="xxx");

I like this solution, works smoothly for me.. here is it! UPDATE tbl SET myDate1= #12/12/2012# WHERE myDate2=DMax("myDate2","tbl","ID=111"); Thanks!

getting "operation must use an updateable query" :confused:

Is there way to use Group By in Update Query? Certain entity could be getting number of dates, I wish to be able to update the latest date.

For instance Excel has a web equivallent called Google Sheets. Is there something similar for Access?

I wish to be able to create a new queries, forms, e.t.c for him. Am I alone in this world who maintains databases to his customers or am I missing something?

I have built a database to some customer, now need to maintanence it on remote. What is the best way to do that? Caspio or equivallents are not the option.