Search results

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?

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

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?

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.

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.

Having a Union Query that consist of queries : SELECT * FROM Degree5Alert UNION SELECT * FROM Degree6Alert UNION SELECT * FROM Degree6PAlert UNION SELECT * FROM Degree11Alert UNION SELECT * FROM Degree12Alert UNION SELECT * FROM Degree13Alert UNION SELECT * FROM Degree14Alert UNION SELECT *...

Something does not work When trying to get a value from the table, getting an error "A runsql action requires an argument consisting of an sql statement" Private Sub cboEmpID_AfterUpdate() Dim SQL As String SQL = "SELECT ID, Class" & _ " From Employee " & _ "...

I'm getting lost due to multiple criterias within the queries. What's the best practice to comment the criterias?

Each employee may have various degrees from different dates. How correctly to to build a table so that same employee will not get already existing degree?

Trying to create a form that updates FinishWork for employee. However getting a error. Private Sub btnFinishWork_Click() ' MsgBox cboID ' MsgBox txtFinishWork CurrentDb.Execute "UPDATE EmpList " & _ " SET FinishWork =" & txtFinishWork.Value & _...

Two questions: 1. Could the SQL code be replaced with the query names within the UNION query. 2. Is there way to embed comments within the SQL code?

This One Is Working ..and this one is working However merging both above into one with "OR" operator throw an error of "Data Type Mismatch..". What am I doing wrong?

When is required to create relationships between tables and why is it not enough only select a table in a field raw source? What am I missing?

I wish to get notified every Sunday in 9AM o'clock with the results from the MS Access query. What's the best way to do that? Thank you

I can make one condition expression , as shown, however I have more than 10 conditions. I do prefer to build them as a nested IIF statement in VBA. What's the right way to do that?

Managing Dynamic Emails in EMailDatabaseObject I have a query that alerting once an employee has a birthday. Now I wish that "..wishes" report will be sent to that employee. I can put in AutoExec only static email , a@b.com but not relevant employee email from a table..

Having a table DegreeDate Fields are : ID, DegreeDate, Degree. Each ID may have more than one degree. Wish to build a query that shows only those whose degree is 50. If same ID has higher degree he will not be shown. Will appreciate your help..

I have excel file with two fields: Website column is a function: =+HYPERLINK("http://www."&A3&".com","Press..") When importing to Access , the link is disappeared. How to keep the 'Website' field value, based on 'Model' (as in Excel)?

I have a range of board serial numbers, starting from SN0000001 and till SN0001000. How can I create automatically 1000 records, what the VBA code to do that?