Search results

I've been searching the forums for a little while now and have had no luck in finding the solution. I tried looking under for "VBA editing SQL Query" and other various tags. What I am looking to do is create a VB code that edits a pre-existing crosstab query. I have been unsuccessful in...

I am also interested in attempting to do something similar. At the moment I do not believe there is a 'simple' solution. I did read somewhere that the ANDROID OS does support SQLite. I am banking on getting a new phone soon and this inspired me: http://apcmag.com/windows-phone-7.htm The...

Thank you for that sample database... it helped my problem a lot. I was trying to find a way to make a static frame for my crosstab query

I already noticed a flaw that would happen with this crosstab query. When there is no value, there is no column header. See attached. Since 11, 15, 16 have no values... They will be no date header for those days, which is problematic. How would i make a crosstab query that shows all 31 days...

I'm confused. It allows me to make new records. Go to the last record and click your "Next Record" button and it goes to a new record window.

Next problem. Now that i have the crosstab query working. I cannot get the column heading to sort by date. It appears to go by what ever shows up first in the input record Example: Any hints for solving this? I tried changing the SORT: to Ascending and it doesn't do anything. PARAMETERS...

Thank you so much.

I created a cross tab query that is based upon another query. Crosstab Query TRANSFORM First(Query_Reports_Range.[Vent]) AS FirstOfVent SELECT Query_Reports_Range.[MedID] FROM Query_Reports_Range GROUP BY Query_Reports_Range.[MedID] PIVOT Format([Daily_Rounds_Date],"Short Date");It works...

Here is an updated version of that sample database I linked earlier. You navigate around via search. Search allows you to open up worker overview. Overview allows you to View Detailed Worklog (double click on list), add to the worklog or go back to search. (I should of added detailed...

If someone comes in and works and the morning then skips afternoon and works the night. Those two work periods should be seperate and get their own record. imo I've never done payroll. I just know a majority of systems work on conditional statements. If Bob works past the 10hour point in a...

I would spend a lot more time into considering what you want your database to do and work from there. Setting up the tables should be your first priority, not creating forms. I really recommend changing your Emp_Work_Hours table. All you really need for imputing times are...

Start from the forum index. Click a topic and after loads you should see a NEW THREAD button. The button is right above the text "Threads in Forum : Reports" [IMG]

Start from the forum index. Click a topic and after loads you should see a NEW THREAD button. The button is right above the text "Threads in Forum : Reports"

I made a sample database that you can reference. It has a few things in it. Multi-Search, Double-Click Listbox->Open related form and example of a combo box. I would recommend not creating fields for AM/PM/Overtime if possible. Just keep it basic. Two fields: ClockIn/ClockOut. I don't...

I am new to the whole Access scene. I don't quite understand what rst/dao are so I got really confused looking at the code mentioned ealier. At first I tried using the code in my databse. Surpise... it didn't work. It failed saying something like 'invaid field name'. Dim db As DAO.Database...

Maybe this will help. I found this example after looking to do something similar. The example uses a listbox but the concept is still there. I don't remember where I got this example from. All credit goes to them... I did not create this example database.

I'm fresh to the database scene and looking to learn MS Access. I've heard great things about the program and these forums. Should be a fun journey... Acelink

Help with SubForms & List Box Hi... I am new to Access and just learning about databases. I created a scenario for myself and am trying to create a database. But I hit a snag Right now I'm trying to create an overview form where I can glance at the basics and get just the bare...