Recent content by sp1260

thank you so much for the help. I really don't feel comfortable uploading the database since it contain the local government data I work for. I decided to put customized navigation buttons which is working so far. However, it has too be something in the macro settings. Some of the end users is...

Yes, I can enter a record through both (form and table).

I detected that the macro for the add form is not working properly. What I did was install the edit macro which works but it trying to make it prompt to a new record when the user open the Add new record command button. The end users get an error message cannot go to a specific record. click ok...

I have database that I created a Macro to load a form in the add mode. However, when I split the database the form stopped loading. However if I add the form in the edit mode is seem to load but I need it to open with a new record form. Can you put the condition new to open the form with a new...

Here i the SQL view:SELECT [Open Records].[Date Receipt], [Open Records].[Requestor], [Open Records].[Phone], [Open Records].[Completion_Date], DateDiff("d",[DateReceipt],[Completion_Date]) AS Expr1 FROM [Open Records] WHERE (((DateDiff("d",[DateReceipt],[Completion_Date]))<5));

I created a database to track the number of Open Records Request for the city. My manager would like me to provide stats on the number of requests process. I created a query to calculate the time lapsed and would like to calculate the percentage of requests less than 5 days to process. One...