Search results

Hey guys, I haev a form from which I have users input data. I would like to have a button when a record is complete and does not need to have any more work done to it. I don't really know where to start. I have a field in the table that signifies whether or not the record is complete. I just...

Hey guys, Is it possible to have a data grid view AND regular text boxes on the same form? How would I do this?

I'm trying to run a make table query, and I'd like to automate it. Is there any way I can do this through a script so that I don't have to answer Yes/No to any of the pop ups? I turned off the notifications, but I still get the odd pop up.

Hey guys, I'm trying to pull data that has a due date within 30 days from the current date. I'm trying to use WHERE x <= Now() + 30 but I'm getting incorrect records. Can someone please help me out? Thanks.

Hey guys, I'm a little lost in my logic here for some reason. I have a table that has 6 dates. I'll label them as 1 to 6. Date 1 > Date 2 > Date 3 > Date 4 > Date 5 > Date 6. I would like to run a query to ensure that this holds true. Can anyone give me a little help on this? Do I have to do...

Hey guys, I have a field in my table that displays as a Combo Box with it's values coming from a defined value list. When I display this box in a columnar style form, the drop down works, but when you select something, it still shows a blank box. The data is actually written to the table, but...

I am having trouble with a make-table query. I run a query that populates my website with data daily. I have a bunch of fields in the db that I wanted to be displayed as one field on the website, so in my query I concatenated them. My website is able to distinguish which fields are text and...

Hey guys, I'm not sure what happened, but my database size has gone from about 60MB to 290MB. I have added about 10 new records and had an AuditTrail function keeping track of history. I had problems with too many entries in this field, so I deleted the field and started fresh. I have also...

Hey guys, I'm not too sure how to describe this, but here's a stab at it. I have a list of ID's which contain a few duplicates. I want to make a query that concat's all the ID's and show the non-similar data in a separate column. Something like... ID || Name 1 || 1 1 || 2 1 || 3 1 ||...

Hey guys, Is there a way to have FULLY automated macros run? I would like to use Windows Scheduler to open my Macro which then runs a couple queries. Is there a way to do this unattended?

Hey guys, I'm trying to create a macro and I'm not finding success. I have a Macro that contains OpenQuery - qryExportNames CopyObject - tblNames How do I handle all the pop-ups that occur? Is there any way I can automatically select the YES? There are two or three of these.

Hey guys, I have a Macro that exports a table to a db that works fine. Is it possible to have the Macro enter a password to the message box and press enter automatically?

Hey guys, I have a table with 50 records and another table with 10 records. The table qith 10 records correspond to 10 of the records in the larger table. How do I make a query to show all 50 records, but include the extra fields from the 10 records where applicable? They way my query runs only...

Hey guys, I'm creating a sub form which would have a couple common fields from another table. This form will be used for data entry. Is there a function that someone can show me so that when the user enters in a specific detail, the other fields will populate with the corresponding data? Let me...

Hey guys, I want to learn how to make a form that a user can fill out on my webpage and update it to the database. When I create a Page within Access, I cannot update any of the fields. Is there a property I have to check off? everything is a default right now.

Hey guys, If I change the startup properties to not show full menus, how do I get around that to be able to see them again?

Hey guys, I'm creating a database based on an Excel file. The Excel file has about 180 columns and are only linked by to distinct fields. Is there any possible way that I can break this down into easier to manage tables? There are different categories of columns such as Financial Info Personal...

Hey guys, I'm looking to update two fields based on another field through a form. Basically a user will enter a number into Site_Key on a form. I would like two other fields to be updated to this number as soon as they do it or click on another field. Can someone help me with a macro for this...

Hey guys, I'm trying to move a group of fields to a new table. I want the data to follow it. Is there an easy way to do this?

Hey guys, I'm curious to know if it is possible to kick users off your db so you can make changes. Is it possible to send them a message to save and close within 30 seconds, or just send them a messgae. I guess I want to know whether I can 1) Kick a user off 2) Send them a message 3) Send a...