Recent content by romio

Got it working, thanks Oldsoftboss.

On my login form, after the user enters the username and password he will have to go manually using the mouse to point at the Enter command button, is it possible to make in a way that after the user enters the password and hit enter proceeds as clicking on the enter command button

i have tried have a refresh command box with the following: Dim strSql As String strSql = "SELECT Records.ID, Records.Name, Records.Description, Records.Department, Records.ProblemDesc, Records.SolutionDesc, Records.ITName, Records.RDay, Records.RMonth, Records.RYear, Records.RTime...

well its not working yet, even though i have it sroted, the last record will always appear as last record, Why?

Thanks iago18.

When I open my form the data are sorted through the ID, How can I change that to be sorted through the Year? On my form properties is that the Filter is responsible for sorting?

I have done the mistake of not keeping a backup, what I did is split my database file access and then created my mde file, I need to change some data on my tables, but I get the msg that I cant edit a linked table, is there a way that I could put things back the way it was, also this path that...

After creating my query based on some combo boxes [Forms]![DailyWorkReport]![commonth] which are located on my form I do have a command button that will open the results in a report, how can I show the results on the current form? I have added an image to make things easier

Thanks a lot FoFa. :)

how can i show the name of the current month, using the default value, I use day(now()) and year(now()). I tried using month(now()) and monthname(now()) but they don’t seem to be working! any help? Thanks

I found where the problem comes from, when I deleted [Forms]![DailyWorkForm]![comit] from my query it did work. well [Forms]![DailyWorkForm]![commonth] and [Forms]![DailyWorkForm]![comyear] and [Forms]![DailyWorkForm]![comit] the row source type is value list [Forms]![DailyWorkForm]![comday]...

what i did is delete the query and create one from the scratch, this is the sql code: SELECT Records.ID, Records.Name, Records.Description, Records.Department, Records.ProblemDesc, Records.SolutionDesc, Records.RTime, Records.AMPM, Records.ITName, Records.RDay, Records.RMonth, Records.RYear FROM...

I have added 4 images that will expalin what am trying to do, my form, table and query. Thanks.

I think I found where is the problem, on the same form I do also have 3 combo for day, month and year, but the comyear, commonth, comday and comit are unbound I only added them in order to create my query, the problem is that the query is trying to find the data not form comyear, commonth...

Like [Forms]![DailyWorkForm]![comyear] but I got an error: "You tried to execute a query that does not include the specified expression "Year" as part of an aggregate function."