Search results

Hey Everyone, Quick question i have an access form fully functional works every time, however in some cases there are slight delays, for example even though the loading sign i display turns visible=false after a recent button click, i later access a different button, but this leads to an...

Hey everyone thanks for your help in advance, im trying to insert a new line below the active cell ive tried several attempts but i am getting error 1004. Some attempts are commented out. wks6.Activate With wks6 .Select...

thank you in advance for taking your time to help me out, I currently have a loop running which selects a range, copies and then pastes the values in the required columns. Set wks6 = wkb.Sheets.Add With wks6 Dim rstCP As Recordset...

Hey guys ive been looking online and seeing a lot of comments about cascading deletes, Relationships and enforcing referential Integrity. However i still cannot find my error where i have went wrong, hopefully someone out there is quicker than me, by the way im new in Access. So here is a...

I think it should use GroupBy and aggregate functions to do the following steps I require, however I just can’t get this to work: So say I have the table below but with more records Price Cost Zone Zip Code Weight(lbs) Price Cost Freight Value 5 K0K...

Hey people, Ive been trying too serach stuff on the net but got no solution, hopefully i can get help from your guys, my issue is i have a main report which contains multiple sub reports which are dvided by bage breaks, then within each subreport i have a page break in one of the footers. Now...

I have to two different forms, however i have a foreign key in one of my other forms however the data doesn't seem to be automatically linked to it. When i created the two forms into one they are linked however, so my question is how can i do the same but in two separate forms ???

i have a uniqueZip table which has a set of unique rows with a certain code, now my goal is to update the Route tbl to have the match code by comparing the rows from one table to the other. This is my sql statement however this does not change any rows even though there is matching data. Can...

I have a table with five fields, | Zip code | Data 1 | Data 2 | Data 3 | Code | The Data 1, 2, and 3 can have duplicates, so my goal is to gather all three fields and find the unique rows and assign a code to them, therefore they can reflect it to all the...

=[Forms]![Route Form]![ CreatorDD]+"_"+[Forms]![Route Form]![OriginDD]+"_"+[DAYS OF]+"_"+[SERVICE TYPE]+"_"+[EXTRA DAYS]+"EX"" From the code above every time I have nothing in the field [EXTRA TRANSIT DAYS] this string is not printed out, I want to place like a if statement in here as so If...

I want to create a form with a checkbox option where the user can select either a 12 or 24 time format, followed by an listbox option where they will then select a time interval either an 30 min or hour up to 12 (ex 30 min interval 9:00am - 9:30 am - 10:00am and so on), followed by inputbox...